Dear All,
I would like to seek help inside VA report, how to create a measure or aggregated measure with date ranges.
I have a categories between 2 date ranges such as
Categories Date start Date end
A 01JAN2015 31JAN2015
B 01JAN2015 31DEC2015
C 02FEB2015 28FEB2015
D 02FEB2015 31DEC2015
next to create a new aggregated measure in report graph to show something like the image
so B will count/sum/ etc in each month of 2015 the bar chart.
http://s53.photobucket.com/user/elenatec/media/Bar%20Chart.png.html
I have tried to use VA text calculated item
( Month('Trading_date'n) BetweenInclusive(Month('Transaction Start Date'n), Month('Transaction End Date'n)) )
but i would like to have something like VA Agre.png
http://s53.photobucket.com/user/elenatec/media/VA%20Agre.png.html
Regards,
Ong
Hello Ong,
I'm not completely sure I understand what you want to do.
Unfortunately, you cannot use date operators such as Month() in an aggregated measure expression.
We do have Periodic operators in aggregated expressions, which can make calculations such as the year-to-date monthly sum. I'm not sure if that would be helpful to you with your date ranges however. Possibly some combination of filters on the date ranges (or on your "Categories" variable) plus a year-to-date periodic operator (CumulativePeriod) might help.
Thanks,
Sam
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.