Page History
...
- Hover over the calculation in the Field List of the Data step and click on the drop down menu to open it
- Select the Edit Calculation option
Copy a Calculated Field
To copy a calculated field:
- Hover over the calculation in the Field List of the Data step and click on the drop down menu to open it. Select the Copy option.
- A confirmation popup is displayed, click on Ok to create a copy of the selected field.
The new field will have the same name as the old field with “Copy” appended to the end. You can rename this field as required. Note that copying calculated fields also works at subquery level.
Delete a Calculated Field
...
- Hover over the calculation in the Field List of the Data step and click on the drop down menu to open it
- Select the Delete option
Formatting Calculated Field Columns
Users can further format the resultant column of a calculated field. Click here for information on Column Formatting.
Note that a description setting is also provided for calculated field columns that allow users to provide a description to aid report writers to clearly understand the purpose and content of this field.
Calculated Total
Much like dimension and metric fields, you can also create an aggregated total on a calculated field. This is done by using the Calculated Total option, which uses the calculation to create the total.
Note: Calculated Total is not supported in charts, except Numeric Display.
Expand | ||
---|---|---|
| ||
|
...