Crosstab Tool

Introduction to the Crosstab Tool.

Kevin Yang avatar
Written by Kevin Yang
Updated over a week ago

Crosstabs are sometimes referred to as contingency tables, data tabulations, or pivot tables. They enable you the explore the relationship between two variables. For example, lets say you have found the painpoints present in an onboarding process. Are these painpoints distributed evenly across each customer segment? Does the age of the person make a difference? Do any of the painpoints increase or decrease in particular months? The Crosstab tool allows you to easily answer these questions.

Setting the dimensions

The crosstab compares two attributes, these are the 'dimensions' of the crosstab. The first dimension uses the setting from the 'By understanding' control which is typically 'Concepts' or your analysis. The second dimension defaults to the first available date dimension. In the example above the second dimension has been changed to a strucutured attribute representing 'Cabin Class'.

To change the dimension, click on the dimensions headings or dimension labels and choose from your list of available attributes.

Controlling the Metric

The 'metric' is the value that displays in the cells of the crosstab table. It can be controlled by the 'Metric' setting in the status bar area.

By default the metric is set to Frequency % calculated against the second dimension (in this case 'Cabin Class'). When you select a metric that needs to compare to a background value (Frequency %, Impact, Difference) you must also select this background value by choosing either a dimension or 'Overall'.

Switching the orientation

Want to quickly switch the currently selected dimensions between being displayed as the row or the column? Click the 'Switch Row/Column' button.

Other chart types

The Column Chart displays the two dimensions in a either a column or bar type chart that is either stacked (if available for the selected metric) or grouped.

The Table displays the two dimensions in a table format.

Did this answer your question?