how to group records with the same data from select multiple field

[JPMontagne]

I have a Dashboard bar chart that is displaying two cell values where there should be one. The source is a Survery123 form with a select multiple field with options A, B, C, D. Based on what order the user chooses options, I can have multiple records with B,C and others with C,B. Is there a way to merge these two values into one without making changes to the Survey123 or web map?

[Neal_t_k]

You could do a new data expression to recategorize that column to be a consistent order.

This isn't an exact example, but gives a couple different ways you can go about recategorizing. https://community.esri.com/t5/arcgis-dashboards-questions/dashboard-series-how-to-group-year-of-birt...

or

You could change your selector options up a little bit.  Using Define Values (A, B, C, D), select multiple, and operator = "contains".    Users could then  select B and C and any record that contained a B or a C would be filtered.  Not sure from you description if that would work for you as for an example, selecting B would get you B; A, B ; B, C; and B, D etc.

[JPMontagne]

Thank you for your suggestion, Neal_t_k, you helped me find the Arcade code posted on GitHub that solved this.

[JPMontagne]

I found an even better solution that split my defined values into their separate components, so that I could graph A, B, C and D separately. Thank you to the author who provided this:
https://github.com/Esri/arcade-expressions/blob/master/dashboard/dashboard_data/SplitCategories(PieC...