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
  • 361 views
D
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

D
Forum|alt.badge.img+1
  • designGNV
  • 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
  • MatthewM
  • 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

    D
    Forum|alt.badge.img+1
    • designGNV
    • 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!

    K
    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!!

      Terms & ConditionsAccessibility statement