Show number of responses that fit within a range | XM Community
Skip to main content
Solved

Show number of responses that fit within a range

  • September 15, 2021
  • 4 replies
  • 77 views

Forum|alt.badge.img

On a CX dashboard widget, is it possible to show how many responses fall within a range? So out of 100 points, how many fall between 90-100, 80-89.9, etc? Ideally, the ranges would be rows, rather than a filter on the entire widget.
Additionally, I need to average the scores gained from individual respondents, and roll those up to the ranges above. I started to use a custom metric for this, but got stuck once I couldn't use it to filter. (This step is why I don't think embedded data will work for the first step)
As background, I've been able to do this in Data Studio, but I used CASE logic to create the ranges. I'm trying to figure out if you can achieve something similar in Qualtrics or not.
Any help is appreciated!

Best answer by InessaG

You can create a custom field (bucketing or formula) in your survey's Data & Analysis tab, and then map it into your dashboard. That should then give you the desired behavior, I believe.

4 replies

InessaG
Level 5 ●●●●●
Forum|alt.badge.img+19
  • Level 5 ●●●●●
  • Answer
  • September 15, 2021

You can create a custom field (bucketing or formula) in your survey's Data & Analysis tab, and then map it into your dashboard. That should then give you the desired behavior, I believe.


SabrinaC
Level 3 ●●●
Forum|alt.badge.img+19
  • Level 3 ●●●
  • September 15, 2021

I also like using a simple chart and creating Top Box/Bottom Box metrics to show the ranges. I was only using a 5 pt scale here, but you can define a range.
Top Box.pngThe widget looks like this:
2021-09-15_15-41-03.pngMaybe this is what you are looking for.
Sabrina


Forum|alt.badge.img

Thank you InessaG ! I didn't even know that section existed, that's really helpful.
SabrinaC - I really like the idea of using TopBox/BottomBox for this - do you happen to know if there's a trick that would let you use TopBox/Bottom box with a calculated metric?


SabrinaC
Level 3 ●●●
Forum|alt.badge.img+19
  • Level 3 ●●●
  • September 16, 2021

Katie_Colibri - See if this helps, Custom Metrics (CX)