Configure a calculated field
Dernière mise à jour
Cet article vous a-t-il été utile ?
Dernière mise à jour
Cet article vous a-t-il été utile ?
You have the possibility to add calculated fields. They allow you to create new fields, with the possibility to use many formulas and to apply them on other fields present in your data source.
To add a calculated field to a dashboard, right-click on the name of your data source and select "Add calculated field".
You can also calculate a field from the data view via the f(x) button.
An "Expression Editor" dialog box is opened. You can specify the expression that will be used for your calculated field.
In your calculated field you can use:
line by line expressions.
aggregate calculations using the aggregation functions available in the editor.
window calculations by combining the use of the w function, and aggregation functions.
You can add a comment to the expression that start with /* and end with */
Select the calculated field, right-click and click on "Rename".
Select the calculated field, right-click and click on "Field Type". Then select your type.
Select the calculated field, right-click and click on "Delete".
Select the calculated field, right-click and click on "Duplicate". You can do what you want on the new calculated field.
The calculated field you have created can be identified by its color, which is different from the initial columns in the data view.
aggregate calculations at an intermediate level by combining the use of the aggr() function and aggregation functions. For more details , see .
