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