3 Replies Latest reply: Dec 6, 2015 9:15 AM by Andrew Walker RSS

    Avereges of last n Days of the week

    Robert Mika

      How to calculated averages of the last 5 weeks  of  days of the week using set analysis?

       

      If my Dimension is Day of Week:

       

      M

      T

      W

      Th

      Fr

      Sat

      Sun

       

      I need to take last 5 previous weeks ( not included current) and calculated the averages.

       

      I need the AVG of COUNT not SUM.