Hello,
I would like to plot the number of records on a timeseries for the last 18 months.
EG data :
Remark : dates are DD MM YYYY
Problem id - Open date - Close date
1 - 01/03/2018 - 01/06/2018
2 - 01/04/2018 - 01/06/2018
3 - 01/05/2018 - 01/07/2018
Meaning that on a timeline, the line chart should show 0 problems from start 1/12/2017, 1 problem from 1/3 till 1/4, 2 problems from 1/4 till 1/5, 3 problems from 1/5 till 1/6 and then 1 problem starting from 1/6 till 1/7 and 0 problems from 1/7 till now.
Thanks in advance!
HI!
I think the schedule chart could help you:
I think It is hidden by default and that you can enable it from the objects meny.
//Fredrik
certainly an interesting object, but not suitable for what I need. It needs to be a line chart, and I seem to only be able to have a bar chart, so I can't really use it to show/count the amount of rows. I can only plot out the rows in bars.
What you probably want to do is change your data structure to have a single Date variable and multiple rows for each problem as needed.
Problem ID - Date
1 - 01/04/2018
1 - 01/05/2018
1 - 01/06/2018
2 - 01/04/2018
and so on.
Once you have this structure you can just create a time series plot of Frequency versus Date.
Sam
I didn't know we were talking about so much data. A second dataset that is pre-aggregated by date is probably a good idea.
Out of curiosity, do you know of other software that will visualize your data in the way you're looking for? This might make it easier to convey your needs to the development team.
Thanks,
Sam
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.