Loading...
  • Customer Experience
    Customer Experience
  • Employee Experience
    Employee Experience
  • Brand Experience
    Brand Experience
  • Product Experience
    Product Experience
  • Core XM
    Core XM

Pivot Table Widget (CX)

What's on This Page:


Was this helpful?


The feedback you submit here is used only to help improve this page.

That’s great! Thank you for your feedback!

Thank you for your feedback!


About Pivot Table Widgets

The Pivot Table Widget allows you to create a crosstab between multiple fields. Each cell displays the chosen metric value that corresponds with both the row and column value for that cell. For example, you may wish to display the number of respondents from a given airport that fall into each of the three NPS categories.
Pivot Table widget

Field Type Compatibility

The Pivot Table Widget is compatible with the following field types:

  • Number Set
  • Text Set
  • Multi-Answer Text Set
  • Drill Down
  • Field Group

Only fields with the above type will be available when selecting the Rows and Columns for the Pivot Table.

Qtip: Pivot Tables have a limit of 8,000 dimensions (or cells) within the table. To calculate the dimensions in a Pivot Table, multiply the number of fields values in the table’s rows by the number of metrics used as the table’s columns. For example, let’s say you display two fields, each with 60 values. You also display 5 metrics. To calculate the number of dimensions, multiply 60 x 60 x 5 = 18,000. Since this is over the limit, the table will display an error. To reduce the number of dimensions in your Pivot Table, either remove some rows and columns, or add a widget filter.
a pivot table displaying the error that there are too many dimensions

 

Widget Customization

Formatting Rules

Adding Formatting Rules to your metric allows you to specify how values in a certain range are formatted on the Pivot Table. This is useful if you would like to be able to easily differentiate cells on the table based on their value. To access Formatting Rules:

  1. Click the desired metric.
    image of how to reach formatting rules in a metric for a pivot table
  2. Select the Options tab at the top of the metric window.
  3. Click Edit Rules under Formatting Rules.
  4. Click Add Rule to add a new Formatting Rule.
    image of the add rule button in the formatting rules window
  5. Configure your rule. Use the A button to specify the formatting you’d like to apply. Select a condition from the dropdown and enter a numeric value in the entry box.
    image of the formatting rules editor screen
  6. Use the + sign to add additional formatting rules and the sign to delete rules.

 

Significance Testing in Pivot Tables

You can enable significance testing in a Pivot Table when you use the Top Box/Bottom Box metric and a single value in the X-Axis.  Once you have these, follow the steps below to enable Significance Testing.

  1. Click on the Top Box/Bottom Box metric and select Options.
    Significance Testing checkbox and Confidence Interval dropdown
  2. Select the checkbox next to Enable Significance Testing.
  3. Click on the dropdown menu and select your Confidence Interval.

The Confidence Interval indicates how confident you would like to be that the results generated through the analysis match the general population.

Once you have enabled Significance Testing, you might notice red and green arrows in your pivot table.
Red and Green arrows on Pivot Table

The arrows are determined by the adjusted residual of each cell. Pivot Tables show up to three arrows, depending on the p-value calculated from the adjusted residual. A different number of arrows will be shown depending on the degree of significance of the result. Specifically, one arrow is shown if the p-value is less than alpha (?) where ? = (1 – Confidence Interval), two arrows if the p-value is less than ?/5, and three arrows if the p-value is less than ?/50.

For example, if your confidence level was set to 95%:

p-value <= .05: one arrow

p-value <= .01: two arrows

p-value <= .001: three arrows