By default, when you add a field to a look, it's displayed as a column, with each record having its own row. For example, if you add the user full name field, each user's name would be displayed in rows within a single column:
|
Name |
|---|
|
Anna Yu |
|
Carolyn Winters |
|
Kevin Yates |
Pivoting a field allows you to display the information horizontally, instead of vertically. Continuing the example above, pivoting the user full name field would display each user’s name in a separate column, rather than in rows within a single column:
|
Anna Yu |
Carolyn Winters |
Kevin Yates |
To pivot a field:
-
Open the look in edit mode. To learn how, see Edit a look.
-
In the Data section, click the gear icon for the field you want to pivot:
Note: You can only pivot dimensions.
-
In the menu, select Pivot:
-
To preview the pivot in your visualization, click Run.
-
When you're finished editing, click Save.
Tip
To remove a pivot, click the gear icon for the pivoted field and select Unpivot.