Filter data based on difference between two fields

Grafana Elasticsearch
1

  • What Grafana version and what operating system are you using?
    Grafana v8.5.21, Opensearch data source

  • What are you trying to achieve?
    I want to filter my data series based on the difference between two timestamps. I have two fields - data.tstamp and data.last_accessed and I want to filter my data where I only see data that has data.last_accessed more than three months older than data.tstamp.

  • How are you trying to achieve it?
    I have added filter data.last_accessed:<data.tstamp-3M

  • What happened?
    Filter didn’t work.

  • Did you follow any online instructions? If so, what is the URL?
    I have checked online, but none of the suggestions worked.