12 month Rolling trend

[#1]

How to get 12 month rolling trend from a date field in the script?

[Anonymous]

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

[#3]

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?

eg:

process date

pending date

complete date

12 month trend to each field.

On Sun, Nov 25, 2012 at 11:53 PM, Johannes Sunden