Formula Engine
In the majority of projects, the raw data is not sufficient to create your dashboards. For example, you may have a Country column, but you want to view your sales by continent. To do this, you can add new columns directly in Serenytics, calculated using our formulas module, without any technical knowledge.
You can preview the results of your formulas live (and add aggregates and filters to validate your formula). You can manipulate character strings, dates, numerical values, write conditions, calculate rankings, etc.
Use our formula language to easily filter data by date fields. For example, use the month (-1) syntax to filter the data from the previous month, week (0) to keep only the data for the current week ... Year-To-Date calculations, Last-Year-To-Date or Last-Year-Same-Month become easy to implement.
For advanced needs, you can use the value of a variable in a formula.
For example, if a dynamic dashboard filter is attached to a variable myVariable, you can use this value in a formula with the syntax {{myVariable}}.
This can allow you to create very advanced formulas.
