Help needed to make a table look decent in reporting | XM Community
Skip to main content
Question

Help needed to make a table look decent in reporting

  • August 27, 2020
  • 3 replies
  • 22 views
U
Level 3 ●●●
Forum|alt.badge.img+5

I have a matrix question with only text entry items and I need to find a way to make a report that is essentially structured the same way as the question itself. See screenshot below. This can be done in Results Reporting or New Reporting. I have not been able to find a solution because of how Qualtrics treats text responses. Screenshot of question below and QSF attached.

image.pngQualtrics_Community_Help.qsf

Abhishek_U

3 replies

raperm
Level 2 ●●
Forum|alt.badge.img+6
  • raperm
  • Level 2 ●●
  • September 1, 2020

Hmmmm. You should be able to do this in paginated reporting by adding in the columns. Let me try a bit of testing and get back to you, because I could swear I've done this or something similar to it.

U
Level 3 ●●●
Forum|alt.badge.img+5
  • uhrxx005
  • Author
  • Level 3 ●●●
  • September 1, 2020

I've tried but it was just not looking right. I ended up just setting up a live connection with Google Sheets and putting a hyperlink to the Google Sheets within the report

raperm
Level 2 ●●
Forum|alt.badge.img+6
  • raperm
  • Level 2 ●●
  • September 1, 2020

Okay, so I found a way that MIGHT work for you.
What I did here was to make one table for each team member (name, affiliation). They are "stacked" on top of each other, so what you see in this image is actually three separate tables.
To get the Team Member column, I just put in a text field, and used some spacers (highlighted so you can see them) to space them out so they'll look right in the PDF.
That's about the best solution I could find. Hope it helps you!
report.png

Terms & ConditionsAccessibility statement