Hello Arpan,
Sorry this has continued to be an issue.
On my 7.3 install I am able to get a good result with a very similar aggregated expression:
When I plot this versus Date, I get this:
There are bars for each day because the format of the date variable. Because of the number of category values, you have to zoom in a bit for the bars to be drawn.
If you make your aggregated item based on a date variable with a month format, you could get a result like this:
It should be noted that because of the way the periodic operator works, the first period (year) of data will be missing because there is no previous period to compare to. So if your data is filtered to include only 2014 and 2015, then the values for 2014 will be missing because the 2013 values are not available to calculate the 2014 growth.
I'm not sure why you are not seeing ANY results for your aggregated item when Transaction Date is assigned to the chart and when the inner interval is set to _byMonth_. You might want to contact SAS Technical Support if you are still stuck.
Thanks,
Sam
... View more