We had a simple field where we collected several values. To report on this, I had to create custom calculated metrics with 0/1 for each option had been selected or not. Then redo the calculation if we add more options.

I'd like if multiselect fields could either get a string-joined variant by default (that is just a texta attribute), or that we get an function in explore to do the join, with some delimiter of our choice.

Accordnig to a Zendesk ticket today I got response from an Zendesk on, it's not possible to join or report using built in functions. I didn't find any way myself either.

One alternate solution that might be of use - depending on your use case - might be to create a calculated metric for each multiselect value of choice using an expression like IF ([YourAttribute] = “Label”) THEN 1 ELSE 0 ENDIF, and then include each such metric in the report. Since its a metric, it won't create additional rows.

Then you'd need to do some lookups and string concatenation in Excel or other ways to try to produce a new column with the concatenated 1-values.

Solution is cumbersome to create as you might need to create many calculated metrics, it needs to be maintained if you add more values, and then you'd need to implement the solution to join it, once exported.