Jump to content

# 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)

None of these are working.  Please help!!

##### 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 🙂

## Create an account or sign in to comment

You need to be a member in order to leave a comment

## Create an account

Sign up for a new account in our community. It's easy!

Register a new account

## Sign in

Already have an account? Sign in here.

Sign In Now
×
×
• Create New...