we want to create a filter/dynamic column with multi selection options as below:
High Coverage: 1 to 5
Medium Coverage: 6 to 15
Low Coverage: 16 to 30
Very Low Coverage: 31 to 50.
But we want to limit users selection like: User can only choose adjacent options, like: Users can choose ‘High coverage’ and ‘Medium Coverage’ but not ‘High coverage’ and ‘very low coverage’.
Do we have a function on quicksight to control that? Or any other workaround to achieve the same goal?
Any insights will be much apprecated!
There is no option available to limit the user selection of values listed in the control.
Since this is dynamic selection, try creating a file based dataset with combination of filter1 and filter2.
For example, If filter1 is high, then filter2 is medium.
Using these fields create two parameter control on analysis and enable “Show relevant values only” on parameter2.
Based on selection from Parameter1 and Paramter2, create a calculated filed and limit the data. Let us know if this workaround helps.
Based on selection,