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.