1 Reply Latest reply on Mar 26, 2020 10:58 AM by Hari Ankem

    How to show rolling 13 week total?

    Samantha Howell

      Hi,

       

      I need to show a rolling 13 week total of pipeline created for the last few years. Ideally, this would be dynamic so it could update on it's own every week.

       

      I need each bar on the X-Axis to show 13 weeks worth of data. So, Bar 1 = March 21 - Dec 22, 2nd bar = March 14 - Dec 14, and so on. I've got the 1st one down but I am not sure how to create the others. This is the formula I used:

      DATEADD('week',-13,today())

       

      Any advise on how to go about this? Thanks!