You may need to replace a certain field after creating several components. However, this field is used for several subsequent analysis steps after data editing, including being used to output new fields and create corresponding charts. This document introduces how to replace a specified field with the original data unchanged.
For example, the Type of Contract field is used to edit data and create multiple components in the dashboard, as shown in the following figure. However, it is needed to reclassify this field while keeping other content unchanged.
The Type of Contract field is used for Group Summary in data editing.
Replace the field according to the following procedures.
A successful replacement will not affect data editing and components, as shown in the following figure.
Follow the steps below to replace the Type of Contract field with a new one with the same name.
1. Add a new column in the data table.
2. Delete the old field.
3. Rename the new field to the name of the old field. (Field Settings cannot be the last step of data editing, otherwise, the replacement may fail.)
4. Save and update the data.
Add a new field for replacement before the Group Summary step.
For example, click and add an Assignment Column to reclassify the Type of Contract field, as shown in the following figure.
Note:You should conduct this step before referencing the Type of Contract field for data processing, otherwise, the Group Summary step will be marked in red.
The new column is named Type of Contract (New), and the grouping is shown in the following figure.
1. Unselect and rename the old field.
Unselect and rename the old field in Field Settings after adding the column.
2. Rename the new field to Type of Contract.
Rename the Type of Contract (New) field to Type of Contract, the same as the original field.
3. Click Save and Update.
After successful replacement, the grouping of the Type of Contract field is changed to Short Term Order and Long Term Order with other content unchanged.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy