A Delta column calculates summaries against two measures and displays the difference between these summaries. This difference can be demonstrated using a numeric value displayed within the delta element and an additional delta indication.
Delta columns are bound to two measures that provide two values: the Actual value and the Target value. The column displays the difference between these values.
When you switch the column type to Delta, its menu allows you to specify Actual and Target measures.
Values in the Delta column can be displayed as text or bars.
To switch between these modes, go to the Delta column's menu, expand the Delta Options group and select the Display Mode.
If the display mode is set to Value, the Delta Options group displays options that allow you to configure delta values and indication.
You can use the Value type option to specify which values should be displayed in the Delta column.
|Actual value||Absolute variation||Percent variation||Percent of target|
To specify the condition for displaying a delta indication, use the Result indication option.
|Greater is good||Less is good||Warning if greater||Warning if less||No indication|
Note that the -0.20% has no indication regardless of the specified Result indication. You can do this by setting the Threshold type and Threshold value options. For instance, to disable indication for delta values less than 0.3% or greater than -0.3%, set the Threshold type to Percent and Threshold value to 0.3.