I am working to create tables and visuals to mimic those from a tool we are offboarding using data from our Postgres DB. That tool allows parameters to be passed directly into the query (and within various CTEs) rather than just at the very end (via filters). Is there a way to pass filter parameters directly into the query within Quicksight? For some of our lighter dashboards filtering in the end works well but for others the filters need to be applied in an early CTE for the query to finish in Quicksight.
We are trying to keep the same level of functionality as the previous tool so we want to allow our dashboard users to be able to change the subsets they are looking at without needing to flip through many different sheets.
I have seen posts asking similar questions but no resolution about an actual feature itself.
Hi @jgorelik - Welcome to AWS QuickSight and thanks for posting the question. In data preparation stage or custom sql, I believe you can not pass any parameter. You can put filter to cut down your data volume. One of the approach you can explore to use SPICE for faster performance. It is not always true to mimic same approach from one BI tool to another however the end reporting side and experience should be same.
Thanks for your advice. Dataset parameters seem like they could be the solution to our issue. Right now I am having trouble getting it to show more than just the default value in the analysis. I.e. we have custom SQL code that looks like: select some things where id = <<$parameter>>
where the parameter is defined and has a default value.
When I try and create a control in the analysis built off of the dataset the only option in the control when it is linked to the id data field is the default value. Can you please advise on what I need to fix this so that all id values (and there are < 1000 since i read that is a limitation of the dropdown) are available and when a user selects one, the underlying query and the visuals built on top of it change accordingly