I have a tableau report connected to stored procedure sql server db. The stored procedure has a sql server parameter field linked to a tableau parameter to grab data from the start date to the end date. I want create a prompt page where the user can input the dates they want to select without executing the query each time they change the date.
Currently the query runs each time the user selects a date due to the connection between SQL and Tableau Parameters.
Is there a way to:
- only run the query when a button is clicked
- have an input parameter field set the value of the stored procedure date field
Open to any other suggestions as well.