4 Replies Latest reply on Aug 15, 2018 11:20 AM by Deepak Rai

    Dynamic Interval Question

    Karan Sabnani

      Not sure if the subject line encompasses what I am attempting to do.

       

      I have a date of a process change (7/13/18) and a range of data (by week) before and after. I am trying to show the change in performance since the process change. Since my data includes all weeks since the start of the year, I'd like to only show the number of weeks before the process change date that is equal to the weeks since.

       

      In other words, we are 4 weeks since 7/13, I'd only like to see the 4 weeks before 7/13 etc. and as we move out from that date have the week interval increase both before and after for my data aggregation.