Skip to main content

How to change the date field in your formulas

Every data source has a default date that the KPIs are based on. If your default date is Created date, but you want to see your numbers based on the Updated date, you can easily change the date field, also called date modifier, in your formula.

Example – You created 10 registrations last week and updated 3 of them today. A widget with time period Today can display either 0 or 3, depending on the date field the formula considers.

How to change the date field:

This option belongs to the Data function component in the formula editor (top-left). Whenever you add a new component, you can choose which date field the formula should use.