1 Reply Latest reply on Apr 16, 2018 1:40 PM by Yuriy Fal

    Use a specific moving average in multiple views

    Tim Cady

      I'm trying to use a specific week's rolling average and apply that average to weeks with incomplete data.


      In the example below, I'd like the take the max week (14.4 % in Week 7) and apply that as the to the remaining weeks (10,762 * .144,12,789 * .144, etc.).


      In this example, I'm using rolling 4 weeks. So, Week 7's rate calc is SUM(C5:C8)/SUM(B5:B8)


      I can create the rolling average easy enough using table calculations but I'm struggling to capture that single week's rate to apply in other viz's