This eLearning is the second of three for creating a new query to support a new report page and visualisation. This second step focus on modify the copied query to point to the appropriate columns in the tables and to update the page visualisations to display the appropriate data in the appropriate way. This includes:
- Repointing the fields to the new table
- Deleting unused columns
- Renaming report elements to align to the new table
- Changing field types
- Adding item links
- Adding additional data from other queries
- Renaming columns
- Adding the new table to the Data Model