Score & Average in Choice.

Average provides a single, central value to summarize a set of data, making it easier to understand and compare groups

In AV2, you can assign a score to each choice in your question to calculate a combine weighted average. This is very useful for scale type questions like 1-5 or 1-7 Likert scales, 0-10 NPS scales (likelihood to recommend), or any set of scales or choices that are ordered and can be scored or valued.

Example 1: "Thinking about your checkout experience at the store, how satisfied were you with it?".

• Very dissatisfied = 1
• Somewhat dissatisfied = 2
• Undecided = 3
• Somewhat satisfied = 4
• Very satisfied = 5

Example 2: How likely are you to recommend {{ brand }} to a friend or colleague?

• Detractors (0-6) = -100
• Passives (7-8) = 0
• Promoters (9-10) = 100

Example 3: How often do you receive a visit from your BDM?

• Fortnightly = 24
• Monthly = 12
• Bi-monthly = 6
• Quarterly = 4
• Half yearly = 2
• Don't see them = 0

All of the above can be done in Glow.

To score & average choice questions:

1. Go to a choice question, i.e. any question where by default, you see...
   1. Choices in the Rows
   2. Filters in the Columns
   3. Values set to Column %
2. Click the Choices config (cog) button above your table to the right to open the config menu

3. assign scores to each of your choices, e.g. 1, 2, 3, 4, 5
4. exclude any choice you don't want to incl. in the average calculation, e.g. "n/a" or "don't know".
5. tick Combine Weighted and give your combined variable a name, e.g. "Average" or "NPS" or "Freq. p/year"
6. click Done

6. click the 'Values' slot and change from "Column %" to "Average"

You can now see the average checkout experience satisfaction, i.e. 4.1 out of 5, or "somewhat satisfied" on average. 🎉

To cut across multiple filters

1. change your 'Rows' slot to "Filters"
   • this auto changes your 'Columns' slot to "Choices"
   • it also makes the chart is easier to read.
2. click the '+Filter' button in your table rows (below the "All" filter)
3. select the filters you want to add, e.g. 2 gender, 2 HHI, and 2 retailer filters.
4. click Add (to only this view) or Add Global (to all views in dashboard).

Your cross filters will be added to your chart & table so you can compare averages side by side and see differences between groups, e.g. average checkout satisfaction of 4.07 out of 5 for Male vs. 4.20 for Female.

To change the decimal places, e.g. from 0dp (default) to 1dp or 2dp, go to your dashboard settings (cog icon) at the top left, below the dashboard bar. Note that Decimal Places set in here will be applied to all the views and values in your dashboard, not just the current view.  

Your analysis for Choice Score & Average is now complete! 🥳

In the next article, we'll learn how to Score & Average in Matrix