Follow

Pivot fields

Before you begin

Plans: Professional and Enterprise

Audience: Creators

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:

  1. Open the look in edit mode. To learn how, see Edit a look.

  2. In the Data section, click the gear icon for the field you want to pivot:

    gear_to_group.png

    Note: You can only pivot dimensions.

  3. In the menu, select Pivot:

    pivot.png
  4. To preview the pivot in your visualization, click Run.

  5. When you're finished editing, click Save.

Tip

To remove a pivot, click the gear icon for the pivoted field and select Unpivot.

 
Was this article helpful?

Comments