Date range filter for SQL query graphs

1

How to add a date range filter in the dashboard when the graphs are created using SQL queries?

2

Hi there!

You can achieve this with a Field Filter on the date field, with filter widget type "Date Range"

3

Yes I tried this approach, but when there are two filters, one date and another category then its not working in case where we are using SQL query to design a graph

4

Multiple field filters should work normally, are you getting an error? If so, could you share the error and the query you're trying to run?

5

This was the way I found out to make it work for my case :
WHERE true
[[and "table"."timestamp" >= CAST ({{date_start}} AS date)]]
[[and "table"."timestamp" <= CAST ({{date_end}} AS date)]]

I choose date_start and date_end as date variables.

image
image382×409 8.85 KB