Introduction
In SAP Analytics Cloud, thresholds can be used to compare measures to a fixed range or to other measures. Thresholds provide visual cues in the data so that you can quickly see what areas are doing well, and what areas may need improvements.
Note
- When comparing negative values, pay close attention as the results may not be what you assumed they should be.
- Threshold is defined on a specific hierarchy in the account dimension. If there are multiple hierarchies, you will need to create different thresholds for each hierarchy.
Context:
There are three default ranges with the following labels and colors:
- Green square: OK
- Orange triangle: Warning
- Red circle: Critical
When you open the Threshold panel, you may only see one range (green square followed by the word OK). You can click Add Range to add more Ranges. You can add more ranges or just one and change the label names and colors. Upper and a lower bound values are not mandatory if you have only one range and values cannot overlap.
When you enter the value for your range, the value appears on the line at the bottom of the panel. The value includes a letter to designate whether it is thousands, millions, and so on.
Procedure:
1
From the menu bar, go into Tools (or click on the ellipses (3 dots)) -> Conditional Formatting.
2
Under the Story Defined section, select Add Threshold.
The Threshold panel opens. Choose a Model, choose a measure and choose a Compare To option (Number Range or Measure).
3
Under Ranges, set a lower bound and an upper bound for your range. To add another range, select Add Range. You can add as many Ranges as you want or leave it at a single Range.
Note
- When you add new ranges, the displayed icons and labels will display the default options of OK, Warning or Critical.
You can change the Text, Color and shape for the new Ranges as shown below.
4
You can also add filters to the Threshold. To do this, select Add Filtersand choose a dimension from the list. In the popup that opens, select one or more members and click on OK.
5
To add another threshold, select Add Threshold and follow steps 2-4.
Note
- A warning will appear if you create a threshold range that already exists. You must either change the range or apply additional filters to the threshold.
6
Once you have completed adding thresholds, click Apply.
7
Click on Done.
Result:
The threshold you created will appear in the Conditional Formatting panel and can be added to charts or tables in the story.
