14 Replies Latest reply on Apr 23, 2018 1:25 PM by Deepak Rai

    12 months data from a given date

    Anusha H

      Attached is a sample workbook for a problem I am trying to solve.


      I need to display the measures for only the last 12 months form the values entered in the parameter control called 'Metric Month'. ( Not from today() or current date)


      The data consists of ticket details opened on a daily basis. My data source has a SNAP_Date to capture all tickets opened in that month.


      But each month should be a calculated field which has data from last month 15 th to next month 14th only.



      Any guidance is much appreciated!

      Anusha H,