How to aggregate loop and merge data into one visualization?

Liz2006Liz2006 Community Member, Education Soft Launch Qubie ✭

How to aggregate loop and merge data into one visualization?

Hello -

I created a survey which includes loop and merge to enable up to 10 sets of survey responses. This is part of a site-level assessment that includes teacher feedback and up to 10 teachers can provide feedback on one site-level assessment. The loop and merge function was used to enable the data enterer to enter all of their data for one site into one survey response.

However, I am now building out a template report and finding it difficult to aggregate the loop and merge data into one visualization. Each template report is filtered to include just one site's worth of information, but as I said, up to 10 sets of survey responses. I have 5 questions in each set. I want to be able display a visualization that aggregates all 10 of the responses for question 1, all 10 of the responses for question 2, etc.

I am not able to determine a way to do this and Qualtrics customer support is no help. The only way I can imagine doing this is to create a new variable in which I sum all 10 responses for each of those 5 questions. I am just hoping that there is a more efficient way to do this.

Any suggestions or guidance would be appreciated!


Best Answer

  • PeeyushBansalPeeyushBansal IndiaCommunity Member Wizard ✭✭✭✭✭
    Accepted Answer

    Only way is to stack the data and then uploading this stacked data in some survey and using this survey to prepare aggregate visualiztions.


  • JennySJennyS Community Member Qubie ✭

    Would this only apply to the REPORT visualizations only (ie. assume can do this some how with a dashboard)?

    I am trying to set up the data structure for a survey using loop & merge (before launching, to be safe) and experimenting with the different ways to present results.

  • PeeyushBansalPeeyushBansal IndiaCommunity Member Wizard ✭✭✭✭✭

    @JennyS this also applies to vocalize, we had done similar for customized research team where we stacked the data and than uploaded to another survey and used in vocalize.

  • JennySJennyS Community Member Qubie ✭

    So weird that there is a "loop and merge option" but no easy way to present its' data at the aggregated level - thanks so much anyway Peeyush :)

Sign In to Comment