Use Case: Trending a crosstab of 1 Measure and 1 Dimension over time

by Phil A.

This use case examines how to set up your analysis in Advanced Exploration if you want to crosstab a Measure variable with a Dimension variable, and view this data trended over time period.

Some common examples that this use case can be used for include:

  • Overall Experience by Purpose of Visit, by quarter
  • Number of Records by Visit Frequency, by month
  • Task Completion by Browser Type, by week


For this use case, we'll address the following request: 


I want to view respondents’ monthly average Overall Experience by their Purpose of Visit.


Step 1: Select your Columns (X-Axis) and Rows (Y-Axis)

Note that the Resp_TimeEnd variable specifies when respondents submitted their responses, and can be used for analyses that require trending.

Since we are evaluating data trended over time, you would place the Resp_TimeEnd variable as a Column (X-Axis):


Then, since we are evaluating how data for individual Purpose of Visit groups vary over time, you would place the Purpose of Visit variable as a Row (Y-Axis):


Step 2: Convert the Resp TimeEnd variable from “Year” to “Month Year”

By default, adding the “Resp TimeEnd” variable as a Column / Row provides the data by Year.  For this example, right-click the variable, and select the “Month” option for which the year is also provided:



Step 3: Specify which Measure to calculate

Now that we have specified what variables we want to use in our crosstab, we now want to specify what data to include in our analysis for each of the datapoints in our crosstab. 

The “Color”, “Shape” and “Text” options provided in the Marks card allow you to specify how to show data in your table or chart.  For this example, the data will be shown in “Text” format.

Since we want to evaluate the Overall Experience ratings for each Purpose of Visit over time, select the Overall Experience variable from the Measures menu, and drag it to the "Text" option in the Marks card:


Step 4: Specify how the Measure should be calculated

When adding a Measure to your analysis, it is calculated as a Sum by default (see Step 3).  To analyze the average Overall Experience for each of the Purposes of Visit, convert the Measure from a Sum to an Average by right-clicking the variable, go to “Measure”, then select “Average”.


Making this change updates the data in the chart to show average Overall Experience by Purpose of Visit by MonthYear. 


Step 5: Choose the chart type for your analysis

You can change the chart type for your analysis by using the "Show Me" option in the toolbar.


Additional Use Cases

Aggregate Analysis

Cross-Tabbing 2 Dimensions

Cross-Tabbing 1 Dimension And 1 Measure

Analyzing Data For Multi-Select Questions

Analyzing Respondent-Level Open-Ended Responses

Analyzing Close-Ended Data In Map Format


Trended Analysis

Trending A Dimension Over Time

Trending A Measure Over Time

Trending A Crosstab Of 2 Dimensions Over Time


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Powered by Zendesk