I have 2 date & time parameters passed onto to the direct query. Before the user selects both the parameter value the query run behind based on default value. Any solution to run only when both the parameters are selected?
Hey @anbu4yellow , welcome to the QuickSight community!
The query should re-run when your user makes the parameter selections. Is there something about the data that is returned that is wrong or do you not want visuals to render data until the user makes a selection?
Hi @anbu4yellow
One of your options is to set your default values to something that the user will never select and will never have data. (Say 01-Jan-1900 ). This way the default query does not produce anything.
Once he makes the selections it will trigger the query to get him the desired result.
Regards,
Giri
1 Like
Hi. Its a direct query with start & end date time values. When the user selects the start date query runs even before he selects the time stamp. Same thing with End date paramater. I am looking for a way to not to run any query until he selects both the parameter.
Hi. There is an option under Analysis settings ‘Update Visuals’. But its not showing up in dashboard.
Hello @anbu4yellow, unfortunately, I think this may be a limitation with QuickSight. I ran some testing on my end, but realized the apply button has not been created for the calendar controls like it has with the dropdown controls. Since this is not currently available in QuickSight, I can tag this topic as a feature request for our support team.
The only work-around I can think of to resolve this request would be through an embedded view of the QuickSight dashboard. Are you planning on embedding QuickSight into your application? If so, I can suggest an alternate solution.
Thanks for the response. We are not gonna embed the dashboard. its a direct one. for now i have created a parameters and used that as an action rule to hide the visual based on the parameter value
2 Likes
Hello @anbu4yellow, I appreciate the follow-up. I am glad you were able to create a work-around for now, and I will make sure to tag this topic appropriately for our support team. Thank you!