Polar Cloud
- Action Buttons
- Adding Alerts
- Adding Users
- Adding Users to Alerts
- Alert Action Triggers
- Alert Types
- Calculated Fields
- Can I change my login details ?
- Configure a 4–20mA sensor reading
- Configure a pulse water meter
- Create a conditional alert with several thresholds
- Device Dashboard
- Download Polar App on your phone
- Editing Users
- First Time Setup
- Groups
- Home Screen Navigation
- How do I get my login details?
- How to edit a users account details
- Poll Rates
- Read connection status and Site licence usage
- Remote Programming
- Removing A User
- Schedulers
- Sites
- Software License
- User Roles
- Viewing Active Alerts
- Viewing Historical Alerts
- What happens during an internet or power outage?
- What happens to schedules and alerts during an outage?
- Show all articles (16) Collapse Articles
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
- Choose Sites in the left navigation.
- Find the intended Site and choose its Manage button.
- Open the Calculated Fields tab beside Details, Licence and Webhooks.
- Choose Add Calculated Field and enter a descriptive Calculated Field Name.
Add the source terms
- In Terms, choose Add.
- Choose the variable name, such as A.
- 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.
- 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
- Open the intended Custom Dashboard and enter its edit mode.
- Edit a Graph / Chart widget and choose Add to add a series.
- 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.
- Select the Calculated Field by its name. Choose the intended aggregation and measurement/unit. The example uses Average and kW.
- 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.
- 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.