Skip to main content

Calculated Fields

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.

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
ToNumber() – Convert text to number
ToText() – Convert number to text
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, Day of week, Day of year, Hour, Minute, Second
Time() – Return only time from a date field
How to set the default field value
How to use the decimals