Formulas

12 articles in this collection
Written by Rikke Mathiasen and Kristian Øllegaard

An example on how to use the History Modifier in formula editing

How to set up a formula that tells Plecto to return the number of historical data from a chosen time period.
Written by Rikke Mathiasen
Updated over a week ago

An example on how to use the Last syntax in formula editing

How to set up a formula that tells Plecto to return the number of the latest registration (example of call records).
Written by Rikke Mathiasen
Updated over a week ago

Combining formulas

How to combine formulas.
Written by Rikke Mathiasen
Updated over a week ago

Conditional colors

How to create text color on numbers on your dashboard.
Written by Kristian Øllegaard
Updated over a week ago

Date functions

How to create a date or date and time object in the advanced formula editor.
Written by Kristian Øllegaard
Updated over a week ago

IF statements

Written by Kristian Øllegaard
Updated over a week ago

Lookup functions

An overview of lookup functions in the Advanced formula editor.
Written by Kristian Øllegaard
Updated over a week ago

Date & History Modifiers

How to tell Plecto to return data from another date period than the default one (Date and History modifiers).
Written by Rikke Mathiasen
Updated over a week ago

Month To Date Index

How to set up a month to date index in the Advanced formula editor.
Written by Rikke Mathiasen
Updated over a week ago

Month To Date Target

How to create a formula that shows the daily progress in reaching a target.
Written by Rikke Mathiasen
Updated over a week ago

Prefix / Suffix

How to add a prefix or suffix in the formula editor.
Written by Kristian Øllegaard
Updated over a week ago

Utility functions

Written by Rikke Mathiasen
Updated over a week ago