I created a survey with some questions with multiple choice. I know the answers are stored with comma separating the values so, in my dashboard I used the condition "Include" for every options so I can have a way to see all answers including each choice.
However, comparing the results in my dashboard with the results in the Analyze option in Survey123 (where each option is counted in every answer) the values are completly different and in my dashboard almost half of the answers are not included.
How can I create a serial chart in dashboard that show the numbers of times it was selected as an answer, just like it shows in the survey analyse?
Can you provide some screenshots to show what you expect (survey data) and what you het (dashboard)?
Are you using ArcGIS Dashboards Beta?
I think I came across the same issue. As a workaround I added an hidden extra field in the survey that automatically calculates unique combination of answers so that in the Dashboards serial chart I was able to use the ‘equal to’ criteria based on that field. It’s not ideal, but a working workaround.
if you use Dashboards beta, post this question in the Dashboards beta community. They will let you know there if this a known issue or if they can reproduce it.
When I reported another issue in serial chart, I was told that the serial charts will be be improveds in the next release, being April 13th. Maybe this issue will be fixed as well.
Can this be accomplished within Dashboards using an arcade data expression to pull the data?
Maybe. I don't have a clue how to do it with Arcade. I'm starting with it.
But thank you for the idea.