Filter - Time Series

Good afternoon everyone, I have a question and would like to ask for your help. Is it possible to create a filter that can select more than one month?

I saw the dates with the selectors but they only appear as month, day and previous week. I would like to show something that allows the person to select any month.

Thank you all.

You can use a date range filter for this. If you're looking at the full list of option in the drop down menu then "specific dates" lets you choose a range. You can also modify the filter itself and change the "filter operator" to "date range" to turn the dashboard filter into a date picker for range selections.

Is this what you're looking for?

Hello,
the way you told me it works excellently, but I'm looking for something more practical. I created an image that is merely illustrative of what I want to portray. I tried to do it via SQL but I wasn't very successful. I think it would only work if I had a column in my database with the names of the months. What I want to do is transform the date into the name of the month in the query and pass that to the filter.

You could probably:

  • Write an expression to return the month as a string in the dashboard questions
  • Use a "text" filter with "Custom list" to make a list of months for selection