Hello!

I’ve run into a challenge displaying the responses from a matrix table with carry forward answers.

The survey is setup like this:

Q1 - select all that apply from this list

Q2 - Matrix table carry forward choices, 5 point likert scale for each choice

In the dashboard/dataset these responses have been recorded as separate items instead of all together in a single field.

I want to compare the different choices in a dashboard widget, but cant figure out how to.

For example a line chart with Y axis 1 2 3 4 5 and X axis the choices and a count of total choices.

Or side by side bar graphs.

Basically anything where I dont need to make 10 different widgets all next to each other...

I tried creating a combined data set using the field editor but it saved them as the ratings each respondent chose together - 4/5/1/3 which I cannot use either.

Thanks!