Rename Report Columns and Tables in Procore Analytics 2.0 (Beta)
Objective
To rename report columns for Procore Analytics 2.0.
Background
Some columns have new names in Procore Analytics 2.0. As a result, when migrating existing reports to the new tool, some columns will need to be renamed.
Steps
- Open the Query Editor for the report you need to rename.
- Find the column that is not in Procore Analytics 2.0.
- In the formula bar, replace the Analytics 1.0 column with the new one for Analytics 2.0.
- Another method would be to add a step to rename the columns from Analytics 2.0 to the values you had in your previous report.
- For example, in Analytics 1.0, project_stage_name is now stage_name.
- If you go to the navigation step, you can rename the column here and fix errors in subsequent steps.
- Click Insert after making all updates.
- Repeat this process for any other renamed columns.
- When you return to the error, you will see the issue resolved.