Skip to main content
Print

Calculated Fields

Create and understand Calculated Fields

A Calculated Field is a Site-level derived tag that combines existing measurements or other Calculated Fields on the same Site with an equation. It counts toward the Site tag allowance and is not tied to one physical gateway. Use it on a Custom Dashboard.

Access and preparation

Only the Technician role can create or edit Calculated Fields. Manager alone does not provide this technical permission. You also need access to the intended Site and suitable source measurements. After a role change, log out and back in. If the controls are missing, ask the responsible Manager to check your access and role.

Open the creation form

  1. Choose Sites in the left navigation.
  2. Find the intended Site and choose its Manage button.
  3. Open the Calculated Fields tab beside Details, Licence and Webhooks.
  4. Choose Add Calculated Field and enter a descriptive Calculated Field Name.

Add the source terms

  1. In Terms, choose Add.
  2. Choose the variable name, such as A.
  3. Use the source picker to find the intended Site, gateway, device and measurement tag. Select the actual measurement, then choose Add to include the term.
  4. Repeat for the next source, such as B. Review the Terms table, including each variable, Entity Name and Current Value, to confirm you selected the intended measurements.

Enter the equation and result unit

Enter the formula in Equation, using the assigned variables. For example, A-B subtracts a geyser’s power from the installation’s total power when both sources use compatible units. A calculated result is previewed below the equation.

Select the result’s Measurement and source unit separately. For the power example, choose Electrical, Active power and Kilowatt (kW). Do not type the formula into this unit field. If Equation is empty, saving displays Equation is required; enter the formula in Equation and save again.

The demonstrated form includes Enable Automatic Scaling, which is left unticked in this example. Use compatible source units and a suitable result unit; a unit label alone does not correct an incompatible formula.

Choose Save. Confirm that the field is available for the intended Site and check the preview/result against a hand calculation using the same source values.

Display the field on a Custom Dashboard

  1. Open the intended Custom Dashboard and enter its edit mode.
  2. Edit a Graph / Chart widget and choose Add to add a series.
  3. In the source picker, select the Site and go to Tags. Do not leave a gateway or device selected: a Calculated Field belongs to the Site. Clear those filters if the field is not listed.
  4. Select the Calculated Field by its name. Choose the intended aggregation and measurement/unit. The example uses Average and kW.
  5. Set the legend name, colour and axis as appropriate. Choose Finish Editing, then Save the widget. Save any remaining dashboard edits using its save control.
  6. Compare the plotted result with the source series over the same period and aggregation. A successful save does not by itself prove the formula is correct.

Variables and Calculated Field inputs

Each Calculated Field supports up to 23 distinct input variables, such as A, B and C. A variable can be reused throughout the same equation; repeated appearances do not count as additional variables. For example, (A-B)/A uses two distinct variables.

An input may be another existing Calculated Field on the same Site. Select the intended source field and check its equation and source data before relying on a derived result. Avoid self-referencing or circular calculations. Calculated Fields count toward the Site’s tag allowance; reusing a variable in an equation does not create another tag.

Use meaningful formulas

Supported operations include addition, subtraction, multiplication, division, brackets and powers. For compatible flows, A-B can express net flow. Adding two tank volumes in the same unit can combine stored volume; adding tank heights does not automatically calculate volume. Avoid division by zero and invalid expressions.

History recalculates

Results are calculated on demand from source histories rather than stored as a separate immutable historical record. Changing the equation can change historical chart results. Keep a separate controlled record if you need evidence of an earlier formula and its results.

If the result is missing

  • Check that the source measurements are enabled and have data for the period being viewed.
  • Check the equation, source units, time period and aggregation.
  • For dashboard selection, choose the Site’s Tags without a gateway/device filter.
  • Source polling and history intervals determine the available detail. Raw history is not supported in the same way as for a physical measurement tag.

See Technician permissions, tag usage and history and Polar support.

Table of Contents