How to Create Choice (%) Charted, Sig-Tested Crosstabs?

Choice questions are easy to crosstab and analyse in both a table and chart in AV2

To see your results across multiple filters, i.e. in a crosstab, banner, or time series,

  1. click the '+Filter' button in your table columns (next to the "All" filter in image above)
  2. then select the cross filters you want to add, e.g. 2 gender and 3 age filters
  3. then click Add to add to only this view or Add Global to add to all views

Your filters will be added to both your chart & table.

You can now compare your filters (e.g. gender & age) side by side and see differences between them. 🥳

To pre filter your chart,

  • click the '+Prefilter' button above your chart
  • select your pre filter(s), e.g. by country="AUS".
  • click Add (to prefilter only current view) or Add Global (to prefilter all views)

Note that our sample size has dropped from n=1,003 to n=200, indicating that our pre filter has been applied successfully.

To transpose your chart so that your filters are in the chart x-axis and the choices are in the chart bars

  1. Change the 'Rows' slot to "Filters".
  2. This will autoset the 'Columns' slot to "Choices".
  3. Change your 'Values' slot to "Row %" to retain identical numbers to the previous crosstab

Your filters will now appear on the chart x-axis instead of the choices, i.e. transposed.

Note that whatever appears in your table rows will appear on the chart label axis while the table columns will appear in the chart legend / bars.

To stack bars on top of each other (and sum them together), instead of in a group next to each other, click the chart type icon (4 squares) above your chart to the right and toggle between stack and group chart. The transposed format below allows you to fit a lot more filters into your chart, so you can create bigger crosstabs.

To rotate your chart between vertical bars and horizontal bars, click the rotate button in your chart.

To see trends across time

  1. Use time filters in your table rows, e.g. 2023 Q1, 2023 Q2, 2023 Q3, 2023 Q4.
  2. Set the 'Values' dropdown to Row %.
  3. Change chart type from bar chart to line chart (coming soon!).

[image coming soon!]


To revert back to your original choice view:

  1. Change the 'Rows' slot back to "Choices" (chart x-axis)
  2. This will auto-set your 'Columns' slot to "Filters" (chart bars).
  3. Change the 'Values' slot back to "Column %" so that you get the same numbers as the previous crosstab
  4. Toggle the chart type back to to "Group" bars instead of "Stack" bars.

To sig-test your questions, go to your dashboard settings (top left) and tick "Subset Significance Test". The default will be set to 95% confidence level and this will highlight cells green or red if they're significantly higher or lower than the Total (%) column (if Column %) or Total (%) row (if Row %).

You can also tick "Margin of Error" to see how statistically robust each of your sample sizes are.

To average your choices, see Help Scout: How to Score & Average Choices

Additionally...

Within your view manager, you can duplicate your view, move it up/down, redact (make private), remove, and restore excluded views. If you click on your chart title, you can rename your view.

Within the config menu (the cog icon above your table to the right), you can merge, unmerge, rename, reorder, display, hide, exclude, and even score choices (to calculate a combine weighted average).

Once you're happy with your Choice Analysis, don't forget to click Save to save your analysis.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.