Multiselect buttons - Array to a string

1

Hi @gio

I cannot replay in the other comment, If I use Array to a string option, then How Can I count in a dashboard what is the most common option choose?

I really appreciate it

2

hello @LXM8843,

this can be achieved using multiple Count Where True Operations in the Analysis.

here’s the Table:

Screen Shot
Screen Shot3104×1910 222 KB

here’s the Analysis:
Screen Shot 1
Screen Shot 13104×1910 383 KB

as you can see, Option 1 has 2 records, Option 2 has 1 record, and Option 3 has 0 records. is this what you’re trying to build??

thanks for posting!!

3

Yes Geo, just this … My problem now is that doesnt appear the option “Variable” after Join as you show me in your previous response , Am I doing something wrong ?

image
image1438×334 13.9 KB

4

hello @LXM8843,

the dropdown that is currently open will only be populated with the Array variables you have in your app. could you send a screenshot of the Variables modal from your app??

thanks!!

5

YEs,

image
image1513×708 44.4 KB

6

hello @LXM8843,

if you select Que Mejorar as the Array, and Static Value > , as the delimiter does the variable not save correctly as a String?? for reference: Multiselect buttons - save into table record - #2 by gio.

7

no, maybe we can check tomorrow in our office hours

8

yes, we can review in tomorrow’s Office Hours no problem.

we’ll post an update here once resolved.

9

in today’s Office Hours the solution was found using the Join to String action.