1 Reply Latest reply on Apr 17, 2018 12:04 PM by Tim Dines

    View metric by previous Quarter, current Quarter by Month, and Next Quarter

    John Quintana

      Hello!

       

      I have a data table that show metrics by Previous Quarter, Current Month, and Next Quarter using the following calculated field in the columns shelf:

       

      if (DATEDIFF('quarter', Today(), [Effective Date])=-1 OR

      DATEDIFF('quarter', Dateadd('year',-1,Today()), [Effective Date])=-1)

      then str(year(dateadd('quarter', -1, today())))

       

      + ' ' + str(datepart('quarter', dateadd('quarter',-1, today())))

       

      elseif

       

      DATEDIFF('quarter', Today(), [Effective Date])=1

      OR

      DATEDIFF('quarter', Dateadd('year',-1,Today()), [Effective Date])=1

      then str(year(dateadd('quarter', 1, today())))

       

      + ' ' + str(datepart('quarter', dateadd('quarter', 1, today())))

       

      elseif

       

      DATEDIFF('month', Today(), [Effective Date])=0

      OR

      DATEDIFF('month', Dateadd('year',-1,Today()), [Effective Date])=0

      then str(datename('month', today()))

       

      END

       

      Here is what the current view looks like:

      Capture.JPG

      Where the calculated field displays "April" I need a break down of the Current Quarter by month.

       

      Basically, I need to modify this to show previous Quarter as a whole, Current Quarter by Month, and Next Quarter as a whole.

       

      Thank you!

       

      -JQ