11. Use dynamic variables and pivot data
Multiple dimensions are often easier to understand when you pivot one of the dimensions horizontally.
Each value in the dimension will become a column in your report. This makes the information easier to consume visually and reduces the need to scroll down to find data.
To pivot results by a dimension:
- Hover over the dimension in the field selector and click the pivot icon.
- Click Run to re-run the query.
- To unpivot results, click the field’s gear icon and select the Unpivot option, or click the dimension’s pivot icon again in the field picker.