Multi-date filter for dashboard version

Get Help
1

image
image2492×1046 186 KB

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

2

@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

3

yes,I understand.
thanks.

4

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?

5

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

6

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

7

@beta

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

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