How to Create Choice (%) Charted 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 '+' button in your table columns (next to the "All" filter in image above)
    1. NOT the '+' button above your chart.
  2. then select the filters you want to add, e.g. "18-40yrs", "41-60yrs", "61-100yrs,"
  3. then click Add.

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

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

To pre filter your chart,

  • click the '+' button above your chart
  • select your pre filter(s), e.g. by country="AUS".
  • click "Apply" to apply this filter to only this view OR click "Apply Global" to apply this filter to ALL views in your survey.

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. Set the 'Rows' dropdown to "Filters".
  2. This will autoset the 'Columns' dropdown to "Choices".
  3. Set your 'Values' dropdown 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.

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, e.g. below, we've clicked the '+' button in our table rows and added even MORE filters to our chart and table, which now easily fits 10 filters for all (1), gender (2), age (3), and time (4) in our chart x-axis.

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 go back to your original choice view:

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

Finally...

Within your view manager, you can duplicate your view, move it up/down, and remove view. If you click on your chart title, you can rename your view. We'll cover these in more detail in a separate article.

Within the netting/config menu (click the cog icon next to your choices), you can merge & unmerge choices, rename choices, move choices up/down, hide choices, exclude choices, and even score choices (to calculate a combine weighted average). We'll cover these in more detail in a separate article.

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

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