Editing a calculated column

When you have created a calculated column, you can edit it from within the expanded Data in analysis flyout, or from the Data canvas.

Before you begin

You must have at least one calculated column available and the analysis must be in Editing mode.

About this task

Tip: You can also edit a calculated column from the Data canvas, by clicking on the final data table node, and, in the lower left part of the data canvas, clicking Edit calculated column

on the step representing the calculated column.

Procedure

On the authoring bar, click Data in analysis and click on the column of interest.
In the expanded flyout, make sure that Details on selected column is selected.
In the expanded flyout, locate the Expression section and click Edit.
Change the expression and click OK when you are done.

Note: For calculated columns, you cannot change the data type using a selector. Instead, use one of the Conversion functions.
For more information about which types of methods you can use in expressions, see Functions and Operators.

Results

The calculated column is updated.