6 Replies Latest reply on Dec 27, 2015 12:07 PM by Norbert Maijoor

    Comparing dates: comparing single day results to the same day of the week average over a period of time

    Ben Kiviti

      Hello everyone,

       

      I am trying to create a single line chart/ table  which compares the current day of the week page views (for example Monday)
      to the average page views of the same day of the week over a period of  a month back (the last 4 Mondays average).

      results should show a single line which indicates how many page views each zone gets and a different line which shows the average page views each zone got on Mondays over the last 30 days/month

       

      dimensions at use:
      Date, DOW (day of the week), zone


      Measures at use:
      pageviews

       

      Does anyone have any suggestions about handling this matter?

       

      Thanks,
      Ben Kiviti