How can I determine the validity of an item with a start and end date on a timeline?

Basl — Wed, 25 Nov 2020 09:54:42 GMT

Hi,

I'm looking for a way to display the amount of valid IDs per day in a line graph (using distinctive values for 'ID'). I'm on SAS VA 7.5.

So basically, when a date lies between the two date values (dtm_ing_ib_dag_code & dtm_einde_ib_dag_code) the ID is valid. I know how to do it for a specific date using parameters, but would like to see the differences over time. My idea would be to add some sort of 'dummy' calendar to the data set(not linked with the other data) and use that as my timeline. This timeline would also be used in a calculated item to determine the amount of valid IDs.

Would this be a valid solution? Any other suggestions are welcome as well of course.

Thanks in advance!

Regards,

Bas

Re: How can I determine the validity of an item with a start and end date on a timeline?

SASKiwi — Fri, 27 Nov 2020 03:22:14 GMT

I've found using the slider object on a date variable and setting the range of dates to the minimum and maximum values in the data works well. By linking the slider to the line graph you can control the date range graphed to the values chosen on the slider.

topic How can I determine the validity of an item with a start and end date on a timeline? in SAS Visual Analytics

How can I determine the validity of an item with a start and end date on a timeline?

Re: How can I determine the validity of an item with a start and end date on a timeline?