I'm very new to dashboards. I'm creating my first dashboard from the results of a Survey123 form. The survey has some demographic data. For the ethnicity question, one or more values from the following list can be selected:
1 = Asian
2 = Black/African American
3 = Hispanic/Latino(a)
4 = Middle Eastern or South Asian
5 = Native American
6 = Pacific Islander
7 = White
The result of this ethnicity question is a string of values separated by a comma ",". Here are some examples:
3
2,3
7
1,2,3
4
How can I show the results in a serial or pie chart? I'm not sure how to accurately depict the answers to ethnicity question. Most graphs I've seen show the totals for each ethnicity and don't attempt depict multiple values in one answer. I'm trying to find out my options with dashboard as well as best practices to depict these data.