Skip to main content
0%

Calculated Fields in Data Sources

Plecto DocsFeaturesData Sources
Table of contents

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: 👇

Watch videos
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
0%
0%