7 Replies Latest reply on Jan 30, 2019 5:41 AM by Zhouyi Zhang

    Year Over Year Rolling 12 Months Filter Calculation

    Candace Whaley

      Hello All,

       

      I have a Snapshot Date Parameter that displays an end of month snapshot date. I have filter calculations that will display either Current Year or Rolling 12 Month view of performance metrics for my organization based on the Snapshot Date Parameter.

       

      I want to be able to display CY Rolling 12 Months and PY Rolling 12 Months in the same visualization for year-over-year comparison. I was able to create the following filter calculation to get the CY Rolling 12 Months, but, again, I need assistance in creating a PY Rolling 12 Months and a YOY Rolling 12 Months Calculation.

       

      [Snapshot Date] > dateadd('month',-12,date([Snapshot Date Parameter])) and [Snapshot Date] <= date([Snapshot Date Parameter])

       

      Thanks in advance,

      Candace