2 Replies Latest reply: Nov 26, 2012 10:54 AM by dinesh_09 RSS

    12 month Rolling trend

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

        • Re: 12 month Rolling trend
          Johannes Sunden

          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