Open Forum

We use Matrix questions in some of our event surveys and registrations. When pulling these details in a report, the entire answer to the matrix question is in one text field. We have not found a way to break the sub-questions out of the matrix in reporting. Has anyone else had success using and reporting on matrix questions?

Yeah, I feel you on how frustrating this is. The only way we've been able to get the data in a format that works for us is to Export it to Excel and then use the Text to Columns function in data validation. This is why we try to avoid using the matrix option, because it often creates extra work for us. 

We use Matrix questions in some of our event surveys and registrations. When pulling these details in a report, the entire answer to the matrix question is in one text field. We have not found a way to break the sub-questions out of the matrix in reporting. Has anyone else had success using and reporting on matrix questions?

Thanks, Kelli! I just submitted an "idea" to Cvent in the hopes that they can improve the functionality. If you're able to, would you mind upvoting it so that it might get more attention? Thanks again!
Idea Details - Cvent Community

Yeah, I feel you on how frustrating this is. The only way we've been able to get the data in a format that works for us is to Export it to Excel and then use the Text to Columns function in data validation. This is why we try to avoid using the matrix option, because it often creates extra work for us. 

We use Matrix questions in some of our event surveys and registrations. When pulling these details in a report, the entire answer to the matrix question is in one text field. We have not found a way to break the sub-questions out of the matrix in reporting. Has anyone else had success using and reporting on matrix questions?