In Ops Dashboard, I am creating a pie chart from some Survey123 data. The data comes from a 'multiple choice' question so the data is a comma separated list of values. For example, two values are 'invasive_weed,other' and 'other,invasive_weed'. Those are ultimately the same value, but on the Survey the choices were selected in different order. Is there a way that i can combine those two values into a single pie slice?
Thanks