How to Create Matrix (%) Charted Crosstabs?

Matrix 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 'Target' dropdown below your chart / above your table and select a target Statement, e.g. "Lunch". This will also automagically change the 'Rows' dropdown to "Filters".
  2. click the '+' button in your table rows (below the "All" filter).
    1. NOT the '+' button above your chart.
  3. select the filters you want to add, e.g. 2 gender filters, 3 age filters, and 4 time filters,
  4. click Add.

Your filters will be added to both your table rows & chart x-axis

Your choices remain in your table columns & chart bars.

You can now compare your filters e.g. all (1), gender (2), age (3), and time (4) side by side and see differences between them. 🥳

To switch between statements, click the 'Target' dropdown again and click "Breakfast" or "Evening meal" to see the same crosstab for those statements.

To pre filter your chart,

  1. click the '+' button above your chart
  2. select your pre filter(s), e.g. by country="AUS".
  3. 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 see all statements again, in your 'Target' dropdown, select '-'. This will automatically replace the filters in your table with the statements so all statements and all choices are visible again.

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 Matrix 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.