Formulas are at the core of Plecto. Every number displayed on a dashboard comes from a formula. With them, you can express a wide range of calculations that should be made on your data.
Formulas are saved as plain text. However, for it to work correctly it must follow a very specific syntax. You can think of it as a programming language. The language is similar to that of Excel or other spreadsheet software.
Your data in Excel are rows in a spreadsheet and you can filter and manipulate this data based on it's columns. Similarly in Plecto, registrations are the rows and fields are the columns.
You can use the following methods to create a date or date and time object:
You can then pass this date object to the following functions:
Here is an example on how to subtract Danish holidays from a formula: