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:

AP_dynamic_edited.png

 

  1. Hover over the dimension in the field selector and click the pivot icon.
  2. Click Run to re-run the query.
  3. 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.

Was this article helpful?
Sign up to give your opinion about our articles.