Data & Analysis export (3 questions) | XM Community
Skip to main content

Data & Analysis export (3 questions)

  • July 19, 2022
  • 5 replies
  • 28 views

jdmill51
Forum|alt.badge.img+3

  1. In the export, is there a way to split start date and time and end date and time? I have searched the community yet am not finding the information.

  2. Also, is there a way to customize the fields? I have a matrix table and they are each showing individually yet adding the comment above to each question: for example:There are no right or wrong answers. Please answer as honestly as possible. - 1. There are no right or wrong answers. Please answer as honestly as possible. - 2

  3. For duration, can I have it show as minutes and seconds not only seconds?

Thank you.

5 replies

Tom_1842
Level 8 ●●●●●●●●
Forum|alt.badge.img+28
  • Level 8 ●●●●●●●●
  • 909 replies
  • July 20, 2022

Hi there, the Export from the Data & Analysis tab can't really be modified beyond the options available in the Export configurer, but most of what you are looking for can be included in the Export with Embedded Data.
For 1, I think the closest you can come would be to save off date information as Embedded Data at the top and bottom of the Survey Flow, which will capture StartDate for all respondents and EndDate for those that make it all the way through the survey. You could also add other date capture Embedded Data elements throughout the Survey Flow as needed.
For 2, I don't think there is a way to stop the Question text from being included before the statements, but you could create copies of the questions as Embedded Data and then name the fields as desired.
For 3, you can use Math Operations to calculate the minutes at the bottom of the Survey Flow.
Your configured Survey Flow might look something like the below:
SurveyFlow_ExportOptions.png


jdmill51
Forum|alt.badge.img+3
  • Author
  • 4 replies
  • July 20, 2022

Thank you so much Tom! You are a genius!


Tom_1842
Level 8 ●●●●●●●●
Forum|alt.badge.img+28
  • Level 8 ●●●●●●●●
  • 909 replies
  • July 21, 2022

Thanks! Also, for point 2, I forgot about the ability to edit the Question Label in the Survey Builder, like mentioned in this recent post:
https://community.qualtrics.com/XMcommunity/discussion/21645/edit-column-names-for-export#latest
The Embedded Data option will still work though.


jdmill51
Forum|alt.badge.img+3
  • Author
  • 4 replies
  • August 5, 2022

Tom,
One last question regarding the time, if I want to record the end time, I should place this embedded portion above End of Survey correct?
image.png


Tom_1842
Level 8 ●●●●●●●●
Forum|alt.badge.img+28
  • Level 8 ●●●●●●●●
  • 909 replies
  • August 8, 2022

Hi jdmill51 , yup you should be all set!