QuickSight Dashboard- Direct Query Mode

Question & Answer
, , , , , ,
1

Hello Team,

I am new to the QuickSight.

  1. I have StartDate and EndDate parameter/control on QuickSight Dashboard, if user select only start date on QuickSight dashboard , then need to add 7 days in end date without selecting end date on UI.
  2. I have Athena SQL query and using direct query mode, need to pass multi value to the select * from table where booking_number in (<<$BookingNumber>>,) it only works for single value but not for multi value, is there any workaround for this this? if I create filter on Dashboard then sometimes it take time to filter booking number data.
2

Hi @Rameshwar

Welcome to the QuickSight community!

Use one StartDate control + addDateTime() in a calculated field to define a rolling 7-day window automatically.

Switch BookingNumber to a multi-value string parameter and wrap it with IN (<<$BookingNumbers>>) in your Athena query.

Please refer to the below documentations this might be helpful for you.

3

Hi @Rameshwar

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

4

Hi @Rameshwar

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!