Filter by time present NOT in the timestamp column

  • 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