Last updated:
Calculation
The Calculation control is a helper that performs mathematical computations on numerical data from a dataclip. Unlike visual controls, it doesn’t render anything on the dashboard: it produces a value that other controls, such as Gauge or Delta, can consume.
| Setting | Required | Description |
|---|---|---|
| Calculation type | Yes | The operation to apply: Sum, Min, Max, Average, or Count. |
| Mapping | Yes | How data is selected: Datapoints or Reference. |
| Datapoints | Conditional | One or more numerical columns from a dataclip; all their values are included in the calculation. |
| Reference | Conditional | A single column from a dataclip; all its values are included in the calculation. |
Either Datapoints or Reference must be configured. The result recalculates whenever the underlying dataclip data changes, and there’s no user interaction involved.
Typical uses: an aggregated total or average feeding into a Gauge, a target or threshold value, or a comparison value for a Delta control.
- Make sure every selected field actually contains numerical values.
- Use Datapoints to combine multiple columns into one calculation, and Reference to aggregate across all rows of a single column.
- Centralize a calculation here instead of duplicating the same logic across multiple visual controls.
Limitations
Section titled “Limitations”- Only basic aggregations are supported (Sum, Min, Max, Average, Count): no custom formulas or expressions.
- No event handling or user interaction.