topic Re: making bar chart from time intervals in SAS Visual Analytics

making bar chart from time intervals

Qvika — Tue, 13 Oct 2020 11:09:49 GMT

Hi,

I am having trouble making a bar chart from time intervals.

I have a start date (periodstart) and an end date (periodend) per customerID and I would like to make a bar chart per month from this data. The problem is that I don't know how to create an interval and that an interval can contain multiple months. Can somebody help me with this?

My dates look like this:

ID periodstart periodend

200 10JAN2018 15MAR2018

201 21FEB2018 14DEC2018

Re: making bar chart from time intervals

Sam_SAS — Tue, 13 Oct 2020 15:51:08 GMT

Hello,

A calculated item that computes periodend - periodstart should yield the number of days between the two dates. Because the numeric minus operator expects a number, you need to use the TreatAs() operator to perform subtraction on the date variables. That will look like this:

TreatAs(_Number_, 'periodend'n) - TreatAs(_Number_, 'periodstart'n)

The Schedule Chart object might also be of interest here, if it is available in the version of VA that you have.

Let us know if that helps,

Sam