I am new to quicksight and looking to see is it possible to create a submit button in my dashboard. i don’t want quicksight to run query to fetch data for the visual each time i choose or change some value in the filter. Rather i want to select/filter all the values and finally when i hit the submit button i want these values to be passed to the DataSet parameter and run the query only once for my visual. How can I achieve this in QuickSight.
i @Velan,
welcome to the community.
At the moment there is no such submit button.
You can achive this behavior by creating multiple parameters. In the first parameter you enter your filter values. This one stores the values till you submit them. The first parameter is not part of a filter.
A second parameter is linked with the filter. So if you enter data here the datasource will be filtered.
Now you have a table or chart with a navigation button. When you activate the action, it will transfer your data from the first into the second parameter.
In the following picture are 3 parameter (p1,p2 and p3). The navigation action writes the value from p1 to p2 and p3.
Regards,
Nico
1 Like
@Velan ,
Checking in. Did @Nico answer help ? If we do not hear back in the next 3 days, we will archive the question.
Kind regards,
Koushik
Hi @Velan, I am marking this reply as, “Solution,” in case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - QuickSight Arena)