2 Replies Latest reply on Sep 19, 2016 11:12 AM by Aarish Riaz

    Quarter over Quarter Calculation

    Aarish Riaz

      Hello all,

      I'm trying to do a Quarter over Quarter percent difference, in a view showing monthly sales numbers. I'm hoping that when I hover over 1/1/2016, 2/1/2016, or 3/1/2016 data points, I see the percent difference of Q1 2016 from Q1 2015, in tooltip.

       

      DateSales
      1/1/20159
      2/1/201527
      3/1/201523
      Q1 2015 total 59

       

      DateSales
      1/1/20169
      2/1/201627
      3/1/201623
      Q1 2016 total 176

       

      (Q1 2016 - Q12015) /  Q12015

       

      (176-59) / 59 = 1.98 or 198%

       

      When I hover over 1/1/2016, 2/1/2016, or 3/1/2016 I'm looking for "QoQ Change 198%"

       

      Thanks a ton!