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!
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.
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.
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.