Customize ElasticSearch query with custom Timerange

  • What Grafana version and what operating system are you using?
    Grafana 8.1.4

  • What are you trying to achieve?
    I need 2 elastic search queries for the same panel using different time filter
    Explanation :
    I have a database that contains flows data, with flow name and flow size for each row.
    Some flows send data each 5min, others 4hours and others once a day.
    I need to show the total size of each flow.
    Problem :
    If the time range of the dashboard is set to last 6 hours for example, some flows that send data once a day will not be shown, I want them to be shown with a total size of 0

  • How are you trying to achieve it?
    I want one query with wide time filter that get all possible flow names and join the result with an other query that get total size for each flow name according to the dashboard timerange.
    This will get a size of 0 for flow name that are not emmitted in the dashboard timerange

  • What happened?
    I can’t personnalize the time range of a query, and I can’t find how to get all possible flow names with a short dashboard timeRange.

  • What did you expect to happen?
    To put one query with wide timerange and another according to the dashboard timerange

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

Example :

If we put “last 30 minutes”, that’s only show the flows that emit a value in the last 30 minutes, I wan’t to show the others too that don’t emit recently with a publish and deliver of 0