Delta Column

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.


Data Binding Specifics

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.


Display Mode

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.

Delta Values and Indication

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
GridWeb_DeltaColumn_ActualValue GridWeb_DeltaColumn_AbsoluteVariation GridWeb_DeltaColumn_PercentVariation GridWeb_DeltaColumn_PercentOfTarget

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
GridWeb_DeltaColumn_PercentVariation GridWeb_DeltaColumn_LessIsGood GridWeb_DeltaColumn_WarningIfGreater GridWeb_DeltaColumn_WarningIfLess GridWeb_DeltaColumn_NoIndication

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.