I'm building a table report in explore. I want to show values chosen from a multi-select field but currently if more than one option is selected, then a new table row for each option is created. I'd like to just have 1 row per ticket so I'm thinking if I could concatenate the options into a new attribute calculation that would solve the problem but I don't see a formula that would do this.
Please help
Hi @Maeve Tracy, I'm wondering if this article about joining attributes might help you to do what you want - https://support.zendesk.com/hc/en-us/articles/360022298254
Hope this helps!
Hi Rob,
Unfortunately that article does not help. It refers to joining different attributes together. I need to join selected options within the same multi-select attribute. I don't think it's possible :(
Maeve
Hi Maeve Tracy
I'm sorry that wasn't the correct solution. I'm also struggling to see a way to do this. I'm hopeful that someone else will chime in with a solution. If so, I'll ensure it gets documented!
Hi @Maeve Tracy and @John Weng,
Unfortunately, it is not possible to condense multi-select field values into one line within Explore. I recommend sharing this request in our Explore Product Feedback Community!
Best,
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.