How to calculate average for matrix question | Experience Community
Skip to main content

How to calculate average for matrix question

  • Nov 10, 2022 12:09 PM UTC
  • 3 replies
  • 381 views

PeeyushBansal
Level 7 ●●●●●●●
Forum|alt.badge.img+53

I have 5-scale point matrix with 5 statement. I created field group and can show average for individual statements.
But i want to understand how we can calculate average for entire matrix.

3 replies

vgayraud
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+68
  • QPN Level 8 ●●●●●●●●
  • Nov 10, 2022 12:35 PM UTC

My first thought would be to use scoring in the survey options, You can pipe in needed values in EDs if needed.
See https://www.qualtrics.com/support/survey-platform/survey-module/survey-tools/scoring/
It can probably be done with custom metrics directly in the dashboard tho.
https://www.qualtrics.com/support/vocalize/dashboard-settings-cx/custom-metrics/


InessaG
Level 5 ●●●●●
Forum|alt.badge.img+19
  • Level 5 ●●●●●
  • Nov 10, 2022 1:16 PM UTC

Look into Customer Metrics - you can create one where you add all the values in and divide by # of responses * # of questions


CxEx
Level 5 ●●●●●
Forum|alt.badge.img+13
  • Level 5 ●●●●●
  • Jan 13, 2023 3:09 PM UTC

Create field group and average will be average of entire field group.