How to Create an action button with dropdown and displaying the required values

First you would make a multi value param.

Then you would make this your calculated field.

ifelse(in({client_id},${coloredParam}) OR in(NULL,${coloredParam}),{client_id},NULL)

Where client id would be your different measure.

If they are different columns then you would have to list it out like this.

ifelse(in('CTR',${coloredParam}) OR in(NULL,${coloredParam}),{ctr_measure},
in('Frequency',${coloredParam}) OR in(NULL,${coloredParam}),{frequency},NULL)

I don’t know if that will work ^ but you can try.

1 Like