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 revenue example, we can distinguish between 2 cases:
- In the first case, metric values are absolute figures - for example, revenues in USD Mio, number of visitors, etc. Typically we select ‘Percentage Difference’ as the basis for RAG status calculation
- In the second case, metric values are percentage figures - for example market share in percentage or profit margin in the percentage of revenues. Typically we select ‘Absolute Difference’ as the basis for RAG status calculation.
In this case, it is desirable that the actual value is higher than the target value, therefore we do not need to set the high thresholds - in other words, HighRed and HighAmber. Whenever the actual value is above the target value, the RAG status will be green.
If the actual year-to-date value is below the target year-to-date value, we immediately want to see amber, and if the actual year-to-date value is far below the target year-to-date value we want to see a red status. To do this we need to set the ‘LowYellow’ limit very tight, say 0.01 and the ‘LowRed’ limit to 10. This means that if the actual value is more than 0.01% below the target value, the RAG status will be amber, and if the actual value is more than 10% below the target value, the RAG status will be red.
When adding the thresholds, please remember thresholds must only be numbers and decimal points. No commas, no spaces, and no percentage signs.