CX dashboard simple chart percentage of respondents | XM Community
Skip to main content
Solved

CX dashboard simple chart percentage of respondents

  • October 19, 2021
  • 4 replies
  • 254 views

melissakagle
Forum|alt.badge.img

I tried to get help with this problem through Qualtrics support and they suggested I post here. The survey question is a multi response multiple choice where respondents selected all choices that applied to them. I want a simple chart, line chart of the percentages of respondents in each group (cohort) for each year of the fellowship (3, 5, 6) out of the total number of respondents for that cohort/fellowship year that took the survey. I can get the counts but when I try to do the percentages, it's dividing by the count instead of the total respondents (even when I choose count/total column). For example, there were 16 people from the 2018 cohort in Year 3 of the fellowship who selected choice A out of 26 total respondents but when I chose count/total column, the percentage shows as 100% (16/16) instead of 62% (16/26).
I sent an explanation to Qualtrics support and their response was: "Qualtrics line charts are automatically set up to only convey completed responses instead of a percentage of completed responses out of the total possible responses. You will need to create your own custom metric in order for the line chart to reflect your desired result." They referred me to the custom metrics support page.
I couldn't figure out the equation for the custom metric that would give me what I want and, when I asked for help, was advised by Qualtrics that "It's standard procedure to direct you to instructions and help you troubleshoot, but anything that needs to be customized is out of our scope. I sincerely apologize for this." They suggested I post the issue here. Thanks in advance for any help you can give.


Best answer by InessaG

You may want to create custom metrics in this case.

View original

4 replies

InessaG
Level 5 ●●●●●
Forum|alt.badge.img+18
  • Level 5 ●●●●●
  • 410 replies
  • Answer
  • October 19, 2021

You may want to create custom metrics in this case.


melissakagle
Forum|alt.badge.img

I understand that but I cannot figure out the equation to use for the custom metric.


InessaG
Level 5 ●●●●●
Forum|alt.badge.img+18
  • Level 5 ●●●●●
  • 410 replies
  • October 19, 2021

It would be Count with a filter of the specific answer option to that question / Count


melissakagle
Forum|alt.badge.img

Thank you so much!!! That worked!


Leave a Reply