Elasticsearch Filter based on Date column is not working in Grafana

  • What Grafana version and what operating system are you using?
    Grafana 8.2.3 and on Windows

My Data Source is Elasticsearch and I just want to display the document count for 3 time ranges. Like I have 1 filed called ABC in my ES index, so
when ABC < now-15d and ABC > now-30d (give me count)
ABC < now-30d (give this doc count) etc.

In Lucene Query I am giving this same filter but it is not working. Also, I tried from GroupBy → Filters → in FilterQuery gave
ABC < now-15d and ABC > now-30d (which is working perfectly fine in Elastic kibana Discover Lucene Tab and as well as in Kibana Visualization Filter)

But in Grafana it is not showing same count. Filter of this time range is not making any effect, even I tried with different ranges.