How do I count embedded data on a report? | XM Community
Solved

How do I count embedded data on a report?

  • 1 November 2021
  • 4 replies
  • 181 views

Badge +1

Hi. I have a satisfaction survey that I send out when a service is completed. When the user answers the Likert scale, the survey also captures the service type which is embedded in the link.

How do I count the embedded data instead of just showing a long list of each service type? It would look something like..

cat
cat
dog
cat
dog
bird
cat

I want to see:
bird 1
cat 4
dog 2

Thanks!

icon

Best answer by MatthewM 2 November 2021, 22:49

View original

4 replies

Badge +1

As a follow-up question, I want to do a pivot table with the embedded data and the data in the survey, then do some very basic calculations. Something like this..
satisfaction survey.jpg

Userlevel 7
Badge +30

I'm not sure this will work but have you tried changing the Embedded Data fields to Text Set?
image.pngimage.png

Badge +1

Hi! That solved it. I needed to change the content type and get dashboards turned on so I could get pivot table widget. I'm able to show the rows now! I still can't do the calculation, but baby steps. Thank you for your help!

Userlevel 2
Badge +3

https://community.qualtrics.com/XMcommunity/discussion/comment/41564#Comment_41564Mind blown! Been using Qualtrics for 5+ years and never knew this was a thing!!

Leave a Reply