How to get 12 month rolling trend from a date field in the script?
If(DATEFIELD>addmonths(Today(), -12), 1) as Rolling12MonthsFlag
Then you can use Set Analysis with your new calendar flag field to only look at the rolling 12 months.
If you have future dates as well:
If(DATEFIELD>addmonths(Today(), -12) and DATEFIELD<=Today(), 1) as Rolling12MonthsFlag
If there is multiple date fields which needs to be shown the 12 month trend
and how can we make use of variables up here?
12 month trend to each field.
On Sun, Nov 25, 2012 at 11:53 PM, Johannes Sunden
Retrieving data ...