Device

Dashboard

Cake Red

LoRaWAN

Integrations

API

Guides

Formulas

What is a Formula?

Formulas can be used to perform basic mathematical operations and derive measurements based on the current values of other fields.

At the moment, the supported operations are

`+`

, `-`

, `*`

and `/`

. You can use both static expressions as well as other fields in your formula. For example, to calculate a measurement in celsius based on another field that holds the value in Fahrenheit, you would use the formula

`(TEMPERATURE_F - 32) * (5/0)`

, where `TEMPERATURE_F`

is the field identifier of the Fahrenheit-field.Creating a Formula

Defining a formula is very simple. Simply select one or more fields from the "Available Placeholders" list that should provide measured values for the conversion. Use this line also to enter the operations.

Examples

Combining multiple fields into a single one

You can use a formula to combine the measured values of different fields and perform calculations based on these values. This is suitable, for example, for setting up compound values or conditions, where the processing of several measured values is required.

Converting Celsius to Fahrenheit

The following screenshot shows a newly created field and its configuration dialog including the formula for the conversion of a Celsius output value of another field into the unit Fahrenheit.

Each time a new value is being recorded to the

`TEMPERATURE`

field, the formula is executed and the result (temperature in Fahrenheit) is written to the `TEMPERATURE_F`

field.â€‹

Last modified 2yr ago

Export as PDF

Copy link

On this page

What is a Formula?

Creating a Formula

Examples

Combining multiple fields into a single one

Converting Celsius to Fahrenheit