1 2 Previous Next 17 Replies Latest reply on Mar 8, 2019 12:52 PM by Don Wise

    Rolling week comparison

    Caroline Ettinger

      Hello -

      I'm trying to do a rolling comparison by week.  I've read a bunch of previous questions that are similar to mine, but nothing that seems to fit exactly.

       

      Let's take today as an example, I'd like to end up with bar charts that display the following data, but also updates daily and moves everything forward a day (so current week is based on Today().  The measures are FB reactions to posts and ideally I want to display all 7.

       

      MeasuresCurrent Week (2/17 - 3/5)Week Before (2/26 - 2/20)

      Wow

      100105
      Like8075
      Love92120
      Angry2055
      Sorry6789
      Haha9045

       

      Thanks!

        1 2 Previous Next