Custom SQL with dropdown parameter

Q&A
,
1

I am currently working on a dataset in AWS Quick Sight and need to add a dropdown filter for the state field in my query. The SQL query I am using is as follows:

select * from all_flights
where origin_state_abr = <<$State>>

However, I am having trouble configuring this to allow for a dropdown menu that enables the selection of multiple values for the state field. I can only set a single value for $State at the moment.

Could you please provide guidance on how to create a dropdown filter in AWS Quick Sight that supports selecting multiple values for the state field?

2

Hi @MOHAMMAD_SAJEETH, welcome to the Quick Sight Community! Check out this resource:

For example:

select * from all_flights
where origin_state_abr in (<<$States>>)
3
  1. In single value dropdown mode, only one value is shown at a time.
  2. In multi-value dropdown mode, the filter allows multi-select, but the dropdown disappears when I unclick the parameter, and only reappears after resetting.

Could you please provide a detailed solution on how to create a dropdown filter in AWS Quick Sight that supports selecting multiple values for the state field? Including step-by-step instructions and screenshots would be greatly appreciated.