Rolling Calculation in Scorecard

[Kim Price]

I am trying to use the calculated mean and 75th percentiles as scorecard metric thresholds.  I want to use the last 1yr average and 75th percentile but I do not want this calculating every day, so what I have done is this: 

Define periodic conditions: 
$Years_1 = periods(12months,1month,'2018-06-01T06:00:00','America/Chicago').inside(past())
$Monthly = months("America/Chicago").move(6h)

Take a monthly average: 
$Monthly_Avg = $Signal.aggregate(average(), $Monthly, durationKey(),1mo).tostep()

Output is the average over the year:
$Signal.aggregate(average(), $Years_1, durationKey(),1mo).tostep()

The challenge is that today is October 25 and the scorecard metric is only populating/showing coloring through September.  I have tried to extrapolate this value into the future with: 

.forecastconstant(1mo)
.forecastLinear(1mo, 1mo)
.resamplehold(3mo,1mo)

None of these are working.  Please help!!

[Nuraisyah Rosli]

Hi Kim,

Seems like the issue is because you used the .inside(past()) in your Years_1 condition. Any particular reason you want to include that?

 

[Kim Price]

Hi Nuraisyah.  Yes.  The reason I did that was I did not want the calculation to refresh and cause strain on our connection constantly.  Maybe if I remove that it could be my solution though.

[Kim Price]

That fixed it for me!  Thank you 🙂