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.

wdd-grid-columns-overview

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.

GridWeb_DeltaColumn_DataItems

Use the GridDeltaColumn.actualValue and GridDeltaColumn.targetValue properties to specify these measures.

Display Mode

Values in the Delta column can be displayed as text or bars.

GridWeb_DeltaColumn_Bars

To switch between these modes in UI, go to the Delta column's menu, expand the Delta Options group and select the Display Mode.

Use the GridDeltaColumn.displayMode property to switch between these modes in code.

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 the 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.

Use the GridDeltaColumn.deltaOptions property to access options that control the calculation of column values and define the delta indication in code.