I'm looking to see if anyone has managed to come up with an arcade expression to split the choices of a multiselect question and be able to use the expression as a filter to only display results that have responses that include that choice?
I have used the expression here: https://community.esri.com/t5/arcgis-dashboards-questions/arcade-split-comma-delimited-value-into-mu...
to create a pie chart to display total number of responses for each choice.
However when i attempt to use that same expression as a dashboard filter, it filters the results to show results that are only the choice selected.
For example: My question on the survey is regarding reports related to workplace accidents. I have a multiselect question for accident categories (Property Damage, Injury Accident, Non Injury Accident , ect.)
Using the expression linked above, I can filter results to show reports exclusive to one of those. So, setting the filter for property damage would properly display reports that are only reporting property damage. But if the reporter checked property damage and non injury accident, the results are not showing.
I'm looking for the expression to show any result that included the choice.
Any and all advice/ direction is appreciated.
