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,