What are Crime and Arrest trends over Time (eg: by month, day of week, year)?
I am trying to make create a chart that shows the trend over time by month day of week and year.
This is where i am at so far. I see the problem being that my Y value has to be a variable and i do not want it to be a variable. I want it to just count from 0 and up. I want it to be a sum.
Below is what i am trying to achieve but these are not the variables I use. i just found this picture off the SAS website but it also uses a variable in the Y axis which i don't want to use. I want it to be a sum total of the obseravations
Essentially i am trying to create a line chart where my X axis is by year and my Y axis is by the total amount of observations of a specific variable (also known as sum). My data has almost 50000 observations and i am trying to show the amount of "arrests" by weekday and month over time. I might be using the wrong chart but i am very confused on why i have to use a variable on the y axis rather than just a sum total.
The best way to put it is that i am trying to get the below table into a line plot.
sadf
Table of Year by ArrestYear ArrestArrested Not Arrested Total2001200220032004200520062007200820092010201120122013201420152016Total