Does QuickSight provide a way to filter a direct query running against a database, based on filters selected by the user when the report is run?
We have a report that needs to return financial balances for a period of time, based on the filters that a user chooses. So, if the user chooses a specific date, we would be expected to show a balance for that date and for 4 weeks previous, 8 weeks, 12 weeks etc. The only way we can achieve this currently is to have the balance for every single date for the last few financial years returned by our custom SQL query, for each separate account. This results in millions of rows needed in the dataset to cater for every filter date that the user may choose. The query also takes a long time to run because of this.
If the answer to this question is no, would this be something that may become available in the future please?