How do I count embedded data on a report? | XM Community
Skip to main content
Solved

How do I count embedded data on a report?

  • November 1, 2021
  • 4 replies
  • 358 views

Forum|alt.badge.img+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!

Best answer by MatthewM

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

4 replies

Forum|alt.badge.img+1
  • Author
  • November 1, 2021

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


MatthewM
Level 6 ●●●●●●
Forum|alt.badge.img+30
  • Level 6 ●●●●●●
  • Answer
  • November 2, 2021

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


Forum|alt.badge.img+1
  • Author
  • June 6, 2022

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!


Forum|alt.badge.img+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!!