Skip to main content

image

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:

  1. crate two plain text variable. startDate and endDate
  2. give startDate a standard value of 2022-07-01 (for example) and endDate a standard valye of 2024-04-01 (for example)
  3. 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.
  4. 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