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

How to calculate average for matrix question

  • November 10, 2022
  • 3 replies
  • 295 views

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+44

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 6 ●●●●●●
Forum|alt.badge.img+59
  • QPN Level 6 ●●●●●●
  • November 10, 2022

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 ●●●●●
  • November 10, 2022

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 ●●●●●
  • January 13, 2023

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