Multi-value parameter - way to determine if a single value/ multiple values / all values are selected

Q&A
,
1

Multi-value parameter - how to determine if a single value/ multiple values / all values are selected. Given that multi-value parameter is not supported in calculated field.

Thanks!

2

Hi @lbl,
While multi-value parameters can be used in calculated fields for some scenarios, I agree that this may not be one of those times as I’ve worked on a similar requirement for a while with little success (Here’s an old post that explores multi-value params in calc. fields that’s worth checking out
However, this can be accomplished through using customSQL; essentially you’ll want to run a count on the distinct values available. The logic below most likely will have to change based on your desired output but it could look similar to the following:

select
case
when count(distinct <<$param>>) = 1 then 'Single'
when count(distinct <<$param>>) < total_count then 'Multiple'
else 'All'
end as selection_type

Here’s some documentation around using dataset parameters in SQL:

3

Hi @lbl

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

4

Hi @lbl

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!