Pivoting dimensions

Pivoting a field enables you to turn a selected dimension into several columns.

When you pivot a field, it creates a matrix of your data similar to a pivot table in spreadsheet software, or a crosstab report. This is useful for analyzing metrics by different groupings in your data, such as getting counts categories. When you pivot on a dimension, each unique possible value becomes its own column header in the Data table. Any measures you have selected are repeated under each column header. For example, count of Promoter, Passive, and Detractor for a Net Promoter Score1 (NPS) category dimension.

Pivoting a dimension is useful in situations where you have a question involving one dimension by another dimension. For example, to view NPS category by region, pivot the Region field.

Pivot a dimension

You can pivot a dimension either in the field picker or in the data table.

Multiple dimensions are often easier to look at when you pivot one of the dimensions horizontally. Each value in the dimension will become a column. Up to 200 pivoted values for a dimension are supported.

  1. Do one of the following:
    • To select and pivot a dimension at the same time, hover over the field to pivot in the field picker and click Pivot data.

    • To pivot a dimension in the Data table, click the gear icon on the right side of the field and select Pivot.

  2. Add additional dimensions, if necessary, and at least one measure.
  3. Click Run.
  4. To sort a pivoted dimension, click the title of the dimension. To sort by multiple pivoted dimensions, hold down the Shift key and click on the dimension titles in the order that you want them sorted.
    When you are sorting a pivoted measure, any rows with values in that column are sorted first, followed by rows without data in that column (indicated by the null value symbol).
  5. To unpivot results, click the dimension's Pivot data icon again, or click the field's gear icon and select Unpivot.
1 Net Promoter, NPS, and the NPS-related emoticons are registered U.S. trademarks, and Net Promoter Score and Net Promoter System are service marks, of Bain & Company, Inc., NICE Systems, Inc. and Fred Reichheld.