Multi-date filter for dashboard version


#1


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


#2

@aggi
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

@aggi
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

@aggi

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

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