Formula builder

Select Formulas on the side menu. You use this section to aggregate different datapoints with each other, or to do computations. You can use this to create new KPIs for the installation.

1. Create a new formula. Click + New Formula. The Build New Formula window appears.

   Build New Formula

   Name of the calculated datapoint

   e.g. Total Energy Consumption, Average Temperature

   Define Formula Variables

   + Add Variable

   Variable Name

   variable_1

   Type

   Datapoint

   Datapoint

   Search datapoint…

   Aggregation

   Latest

   Build Formula Logic

   Visual Formula Builder

   Visual BuilderAdvanced JSON

   Variable

   Choose variable…

   CancelCreate Formula

2. Set the name of the new datapoint that you are creating.

3. Select the variables based on which you are going to calculate this new datapoint. Click + Add Variable for each one. There are three types:

   Type	What it is
   Datapoint	A datapoint in this installation.
   Weather API	A weather datapoint, based on the location of this installation: temperature, wind speed and direction, irradiance, soil moisture or pressure.
   Constant	A constant value that you define.

   Define Formula Variables

   + Add Variable

   Variable Name

   variable_1

   Type

   Datapoint

   Datapoint

   Search datapoint…

   Aggregation

   Latest

   Variable Name

   variable_2

   Type

   Weather API

   Weather Parameter

   Temperature at 2m

   Variable Name

   variable_3

   Type

   Constant

   Constant Value

   1

4. Define the aggregation in the formula builder. There are two ways: with the Visual Builder, or with the Advanced JSON.

   You can describe the aggregation verbatim and have an LLM generate the JSON.

5. Test the result. In the Live Evaluation Preview, enter test values for the variables and check the calculated result.

   Live Evaluation Preview

   JsonLogic Spec Tree

   {
     "var": "variable_1"
   }

   Test values for evaluation:

   variable_1:1

   Calculated Result:1

6. Create the formula. Click Create Formula.

The calculated datapoints

All created datapoints appear under Calculated Datapoints. They are recorded in the database as a regular datapoint, and can therefore be used anywhere as such. The created datapoints are backfilled to 30 days by default.

Bulk import

For operations that span a large number of datapoints, you can do a bulk import. Under Bulk Operations, download one of the pre-defined templates for operations (offset, scaled sum, average, sum, weighted average, weighted sum, less than, greater than, or combined), fill it in and import it.