I am trying to put data from a survey question into a dashboard via a serial chart, however the question I want to insert is multiple choice. When I view the data in the survey itself you can see it displayed correctly (how I want it to look in the dashboard) however, when I put it in the dashboard it creates a separate "bar" for anyone who selected more than one choice. Is there a way I can combine the bars so it displays like in the survey?
Also, is there a way to rename the fields in a serial chart to get rid of the underscores?
Thanks. Pictures attached for reference.
The dashboard chart isn't parsing the comma-separated values like the survey page, and does not have access to the labels of each value in the list.
The only way to get the dashboard to look like the survey page will be to use a Data Expression. The example expressions are particularly helpful. In fact, one of the expressions is already made with this kind of situation in mind. Though it produces a pie chart, the concept could as easily be used for a serial chart as well.