I have a field called Priority Service which has only one value 'Yes'. In the dashboard I don't want this field as filter instead of that I am using Priority Service as toggle button, where it will show 'Yes' & 'All'.
Now I have created the toggle button where I have taken a variable vPS and showing 'Yes' & 'All' value and when toggling the variable value is changing & it's working fine.
But for this toggle selection I have to change the expression across the dashboard like
Like this way I have to change across the whole dashboard it will be very tedious & hetic because there are lot of expressions where I have to change. But I don't want to change in every places so I was trying to find an alternet approach.
So I was trying to put the condition in Sheet level action.
Action : Select Values Matching Search Crieteria
Field : Priority Service
Value : ='=IF($(vPS) = "Yes", "Yes")'
But this is not working.
Actually my objective was when Priority Service Toggle button value will be 'Yes' then Priority Service filter value will be automatically selected 'Yes' value and when . Priority Service Toggle button value will be 'All' the Priority Service filter value will deselect.
But this is not working. If you have any solution please respond.
