Reports with subsets of question data | XM Community
Skip to main content
Question

Reports with subsets of question data

  • September 23, 2023
  • 3 replies
  • 49 views

Forum|alt.badge.img+1

I am creating a very large survey - upwards of 50 questions.  When I run a report, can I have the report automatically set to run only data from subsets of the questions ie: average weighted mean of questions 1-7, another report that runs the average weighted mean of questions 7-20?  Is this possible? How would I do so?  

3 replies

Nam Nguyen
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+29
  • QPN Level 8 ●●●●●●●●
  • 1096 replies
  • September 23, 2023

 @etmill07 You can use formula to calculate the average weighted mean of the questions you want and use that field in the report. Follow this guide for more detail:  https://www.qualtrics.com/support/survey-platform/data-and-analysis-module/data/add-new-fields/formula-variable-creation/
Let me know if it works


Forum|alt.badge.img+1
  • Author
  • 1 reply
  • September 23, 2023

Yeah I’m having a really hard time figuring out how to implement this.

 


Nam Nguyen
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+29
  • QPN Level 8 ●●●●●●●●
  • 1096 replies
  • September 23, 2023

@etmill07 What’s your average weighted mean equation. The aggregate result of question 1-7?  Whether you use custom metric with dashboard or create field with report, you have to set up the calculation