Creating Story-Defined Thresholds
Thresholds can be used to compare measures to a fixed range or to other measures.
Prerequisites
To create a threshold, you must be on a story page.
- SAP Business Warehouse (BW) connections
- SAP S/4HANA connections
- Out of Context Blending
Context
Use thresholds to provide visual cues for your information, so that you can quickly see what areas are doing well, and what areas may need improvements.
- Green square: OK
- Orange triangle: Warning
- Red circle: Critical
When the Thresholds panel opens, you may only see one range: a green square followed by the word OK. Click Add Range twice to add the Warning and Critical ranges.
You can use as many or as few ranges as you like, and you can change the label names and colors. (However, when you change the icon colors, you may see a circle with your new color, not a triangle or square.)
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.
You do not need to set both an upper and a lower bound if you have only one range. When you add more ranges, you can leave either the upper or lower bound empty.
The following formula/process is used for comparing measures:
if (MeasureB == 0) { \\(Can't divide by 0) MeasureA/|MeasureA| > percentage \\(absolute value of MeasureA) } else if (MeasureB < 0 || MeasureA < 0){ (MeasureA - MeasureB)/|MeasureB| > percentage \\(compare variance to percentage) } else { MeasureA/MeasureB > percentage \\(compare ratio to percentage) }