Sum array length

Grafana Elasticsearch
1

Hi, this should be a simple thing to accomplish but I couldn’t figure out how to do this in Grafana.
Given an index with documents that contain an array, how can I visualize with a graph the sum of the arrays’ length, given time? I already know how to write an ElasticSearch aggregation to accomplish this, but couldn’t figure out how to recreate it within Grafana:

 {
"query": { "match_all": {}},
 "aggs": {
    "HISTOGRAM": {
      "date_histogram": {
        "interval": "5s",
        "field": "timestamp",
        "min_doc_count": 1,
        "extended_bounds": {
          "min": "1590401307829",
          "max": "1590404907829"
        },
        "format": "epoch_millis"
      },
      "aggs": {
        "SUM_LENGTH": {
          "sum": {
            "script": {
              "inline": "doc['my_array'].length"
            }
          }
        }
      }
    }
  }

Just to clarify, I am aware that the Sum aggregation exists as one of the options when creating the query for a specific graph, however the ‘field’ property is mandatory. As a result of adding it, I am getting abnormally high values for some reason, not sure why…

Any help would be appreciated! :smile:

2

is it solved? i am looking for something similar