Add a new metric and complete the information in the pop up. In the metric definition select ‘Automatic Status’. Here you will see five colour lines with four spaces to add values. For the inventory example, we can distinguish 2 cases:
a. Either metric values are absolute figures for example inventory in days, liquidity coverage in months, etc.
➔ then we typically select ‘Percentage Difference’ as the basis for RAG status calculation
b. Or metric values are percentage figures for example receivables in percentage of sales
➔ then we typically select ‘Absolute Difference’ as the basis for RAG status calculation
When adding the thresholds, please remember thresholds must only be numbers and decimal points. No commas, no spaces and no percentage signs In the case of inventory, it is desirable that the actual value is within a specific range of the target value - set both the high thresholds (HighRed and HighAmber) and the low Thresholds (LowAmber and LowRed) reasonably tight.
In this example - assuming that the metric values are percentage figures - the RAG status is green if the year-to-date actual does not deviate more than 3 percentage points above, or below, the year-to-date target value. The RAG status will go to red if the year-to-date actual deviates more than 8 percentage points from the year-to-date target value.