I’m trying to set a metric threshold based on another un-scored control metric (Actuals based on Forecast) and so have used the ‘calculated’ function when defining a goal/red flag metric. The calculation is very simple. I want the goal to be the forecast value and the red flag to be 90% of the forecast value so the calculations I have are:
Red Flag: M(1310) * 0.9
Goal: M(1310) * 1
Where M(1310) is the Forecast value set up in advance.
The problem is, the RAG has inverted so that the red is on the top of the chart and the green at the bottom. i think it might have something to do with negative numbers as the first couple of forecast numbers are -1345 and -1253. has anyone seen this before?