Hello @Experts ,
I have a dataset with client information, including client IDs. There’s a dashboard with a parameter for specific client IDs, and a controller that uses these client IDs for filtering. I also have a custom filter linked to that parameter.
When I access the controller, it shows the specified client IDs correctly. However, when I choose “Select All,” it includes all client IDs, not just the specific ones I mentioned.
I need a quick solution to fix this issue. Please provide me with a solution. Thank you.
Thanks
Hi @SAI_BROTHERS
If i understand your requirement correctly eventhough dataset has client ID attribute , you would like to restrict/specify the control values and let user select any/all of specified client ID list .
I could quickly think of a solution by creating an additional calculated field such that it returns values only for the allowed client-id and static value “not-allowed” for other client-id’s . And create additional filter on this calculated field to exclude any records which are marked as “not-allowed” .
In the below example , filter control on the Region is specified only for AMER & EMEA and even if the user selects “All” option data will be restricted further based on additional filter.
Calculated Field “Allowed-LOV-Region”
Additional Filter to exclude Not-Allowed values
Let us know if this is works.
And if it is, please help the community by marking the answer as a “Solution”.
Thanks
VInod
yes, I will try and let you know
