Page 1 / 1
I think the easiest way to do that will be to have a variable that writes into a filter. That way, you can set the variable to the range you want to show and then, the variable will automatically update the filter. Let me walk you throught the steps:
- crate two plain text variable. startDate and endDate
- give startDate a standard value of 2022-07-01 (for example) and endDate a standard valye of 2024-04-01 (for example)
- Create two dropdowns that show the months and have the selection update the value of the variables. One will update startDate and the other one will update endDate.
- Insert a filter on top of the chart that states FILTER TABLE.DATE > TO_DATE(startDate, FORMAT('%Y-%m-%d') and FILTER TABLE.DATE > TO_DATE(endDate, FORMAT('%Y-%m-%d'))
Tell me if it works for you! Otherwise, feel free to reach out again
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.