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

Rank 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 Choice, e.g. "Brand". This will also automagically change the 'Rows' dropdown to "Filters".
2. Change the 'Values' dropdown below your chart / above your table from 'Total %' to 'Row %'
3. Click '+Filter' button in your table rows (below the "All" filter).
   1. NOT the '+Prefilter' button above your chart.
4. Select the filters you want to add, e.g. 2 gender filters, 3 age filters, and 4 time filters

5a. Click "Add" to add this filter to only this view OR

5b. Click "Add Global" to add this filter to ALL views in your survey.

Your filters will be added to your table rows & chart labels (x-axis)

Your choices remain in your table columns & chart bars/legend. (y-axis)

You can now compare your filters (e.g. all, gender, age, time) side by side and see differences between them.🥳 E.g. Brand is more of a hot sauce buying factor for Males (~60%) than it is for Females (~50%)

To switch between choices, click the 'Target' dropdown again and click e.g. "Taste" or "Price" to see the same crosstab for those choices.

To pre filter your chart,

1. click the '+Prefilter' button above your chart
2. select your pre filter(s), e.g. by country="AUS".
3. click "Add" to apply this filter to only this view OR click "Add 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 choices again,

1. In your 'Target' dropdown, select '-'. This will automatically replace the filters in your table with the choices so all choices and all ranks are visible again.
2. In your 'Values' dropdown, change the values back to "Total %"

Finally...

Within your dashboard settings, you can run significance testing to compare differences across filters in your rank question.

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.

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