cancel
Showing results for 
Search instead for 
Did you mean: 

Dashboard SQL Parameters - how to use 'Allow multiple selection'

Barbara_Ebel-La
Star Contributor
Star Contributor

In version 15, I'm adding a parameter to a dashboard with a value select list.  There are 10 values in the list, and I'd like to use the "Allow multiple selection" checkbox to let the user choose between one or multiple values as parameters.  However, when I save it and refresh the dashboard it tells me "Source has been filtered" which I took to mean there's an error with my data provider.  How do I get the data provider to accept multiple values?

Here is the parameter line in my query:

and trim(attr1599) in '('||@{Trainee}||')'

1 REPLY 1

Barbara_Ebel-La
Star Contributor
Star Contributor
I was overthinking this. This worked:

and trim(attr1599) in ( @{Trainee} )