2 Replies Latest reply: Dec 7, 2014 11:38 PM by Anthony Wood RSS

    Two-Piece Weekly Volume Averages

      Hi,

       

      I am trying to create a bar graph with weeks on the x-axis and volumes on the Y-Axis. After a certain date (i.e. 30 Oct) there is a massive jump in volume due to some initiative that we are undertaking. I am trying to add additional expressions (i.e. Lines) to the chart that show the massive jump in weekly averages for Pre-30 Oct and another for Post- 30 Oct.


      Is there anyway to do this?

        • Re: Two-Piece Weekly Volume Averages
          Nagaian Krishnamoorthy

          You may try adding a vertical reference line for Oct-30, to separate Pre-Oct30 and Post-Oct30.

            • Re: Two-Piece Weekly Volume Averages

              Didn't know you could do that, so thanks very much for your response.

               

              However, it's not quite what I am looking for. I am building a dashboard that calls out the jump in the average number of weekly sign ups to a website (the time periods are not the same, therefore averages are used to even it out).

               

              I have built an expression that computes the average of the 6 months prior to the reference date, 30 Oct. and the results post 30 Oct. I want these to be horizontal lines on the time series chart so that I can easily show what the stat means.

               

              In fact, I found that adding a Total Column Worked!

              Post Oct 30:

              = Count(Total {$<LastDayOfWeekSignedUp={"$(= '>' & date(41948))"}>}Distinct CustomerIdentifier) /

                   Count(Total {$<LastDayOfWeekSignedUp={"$(= '>' & date(41948))"}>}Distinct LastDayOfWeekSignedUp)

               

              Pre Oct 30:

              =Count(Total{$<LastDayOfWeekSignedUp={"$(= '>' & date(BeginSignupMonitoringDate) & '<=' & date(41948))"}>}Distinct CustomerIdentifier)/

              Count(Total{$<LastDayOfWeekSignedUp={"$(= '>' & date(BeginSignupMonitoringDate) & '<=' & date(41948))"}>}Distinct LastDayOfWeekSignedUp)