0%

Calculated Fields in Data Sources

Calculated Fields in data sources

Add new columns and create calculations based on the data you already have. More data options allow you to visualize more accurate KPIs.

Calculated fields are only available in integration and manual data sources (not supported in SQL or API).

Learn how to use Calculated Fields: 👇

Field() – Simple calculations with data source fields

IF() – IF statement

Switch() – Swap field values for something else

Contains() – Check if a text field contains specific values

ToNumber() – Convert text to number

ToText() – Convert number to text

Employee & Team – Include employees or teams in the calculations

DateDiff() – Calculate the difference between two dates

Now() – Return the date and time right now

Date() – Create advanced date calculations or add a static date

Year, Month, Day of month, Day of week, Day of year, Week of year, Hour, Minute, Second

Time() – Return only time from a date field

Timedelta() – Offset a date field

How to set the default field value

How to use the decimals