Multi-date filter for dashboard version


How do I use filters for multiple dates in the dashboard?For example, how to write sql?

@beta
I don’t understand “multi-date”, do you mean ranges? If yes, then you just need to return a date column.
Just for reference, this is the English dashboard time filter options on 0.31.2
image

yes,I understand.
thanks.

How to write sql query statement with date range filter?
Can you give an example?
select nick,dt from demo where dt={{dt}};
Is the sql query with a date range written like this?

@beta
Correct. It just needs to return a date column.

I still don’t quite understand, I hope you can give an example of the actual sql query statement.
Thanks!

@beta

SELECT "name", "date" FROM "table" WHERE {{filter}}

It’s a lot easier, if you post your queries.