-
What Grafana version and what operating system are you using?
Grafana v7.5.4, Linux -
What are you trying to achieve?
The table that I’m working with has the timestamp column, but it also has the trigger_time and execution_date columns (it’s an Airflow DAG trigger_time and execution_date). I want to create a query where I will be able to filter the results by using the trigger_time column
For Queries, I’m using an InfluxQL -
How are you trying to achieve it?
Right now I’m filtering using *WHERE $timeFilter * in my query, but I assume that it is working on this timestamp column and it is working correctly. I tried to use WHERE trigger_time < now() - 7d but I wasn’t able to make it work, I wasn’t receiving any data
Both trigger_time and execution_date are in this kind of format: 2023-03-03T00:00:45.960436
-
What happened?
Received no data - but I didn’t get any errors, it seems like the filtering condition is not right -
What did you expect to happen?
Since trigger_time and timestamp usually match I expected to receive similar results and I didn’t receive any data -
Did you follow any online instructions? If so, what is the URL?
Add and manage variables | Grafana documentation
I will really use some working PoC that I could try by myself
Thanks!