# Rolling Calculation in Scorecard

Go to solution Solved by Nuraisyah Rosli,

## Recommended Posts

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)

##### Share on other sites

• Seeq Team
• Solution

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?

##### Share on other sites

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.

##### Share on other sites

That fixed it for me!  Thank you 🙂