Calculated fields overview
Calculated field is a data field created from the existing fields and applies formulas to them without changing the original data. Calculated fields allow you to create new Dimensions or Measures.
You can use existing dataset fields, constants, and functions in your formulas.
You can create calculated fields from the dataset interface or from the chart wizard:
- Calculated fields from a dataset are available for all the charts created from this dataset.
- Calculated fields from the chart wizard are available for the current chart only.
Calculated fields in datasets
You can use all the fields in the dataset in your calculated field formula, including the previously created calculated fields.
Calculated fields are marked with symbol.
After the calculated field has been created, it becomes available to all the charts and selectors built upon the current dataset. If you want to make this field unavailable for charts and selectors, click the icon on the right of the symbol.
Calculated fields in charts
You can add new fields to a chart when working with it in the chart wizard.
You can use all the fields in the chart in your calculated field formula, including the previously created calculated fields.
Calculated fields are marked with symbol.
A calculated field created in the chart wizard won't be available for other charts or selectors.
Functions
Functions are the main formula components. They allow you to perform different operations with data fields.
Available functions depend on the data source.
Formula format
Formulas must comply with the following requirements:
-
Use square brackets for field names:
[OrderDate] -
Put function arguments in round brackets, separate arguments with a comma:
YEAR([DATE1],[DATE2]) -
Use acceptable formats for constants and field values. For example, use
.to separate fractional values.