- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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