Community Groups are officially here!
We've released Groups, a new feature that enables us to connect community members of similar industries and interests in a shared, private space. You can check out all of the details here, including information about who can join, how to join, and what Groups are currently offered. Please leave your feedback through this Community Groups Feedback Survey.

Charting multiple answers in Customer XM dashboards

DaddyO
DaddyO Salt Lake City, UTCommunity Member - Trial User Qubie ✭
edited June 23 in CX Dashboards

Hello,

I am doing an exit survey for our company. I ask employees their reason for leaving, and there are about 10 options. They get to choose up to three reasons for leaving. How do I chart all the responses in Customer XM? I want to show each possible reason for leaving and how many answered that reason as their #1, #2, and #3 choices.

In Excel, I have to do a PowerPivot to be able to display the data in a chart like this.

Thanks in advance!

Below is how I did it in Excel:

As a follow-up (Dec. 31, 2020), I know how to do this with matrix questions, using the following two help files, but the example above is different:

Field Groups (CX) (qualtrics.com)

Matrix Statements in a Single Widget (qualtrics.com)