Visualize Elastic Query

[yuswanul]

Hello there,

i want to know, how if would like to change this query into a visualization. is it possible?

GET my-index/_search?filter_path=aggregations.percentiles_of_latencies
{
   "size": 0,
  "aggs": {
    "latencies_per_seconds": {
      "date_histogram": {
        "field": "process_timestamp",
        "fixed_interval": "1s"
      },
      "aggs": {
        "latencies": {
          "max": {
            "field": "latencies.request"
          }
        }
      }
    },
    "percentiles_of_latencies": {
      "percentiles_bucket": {
        "buckets_path": "latencies_per_seconds>latencies",
        "percents": [ 95.0, 99.0 ]         
      }
    }
  },
  "query": {
    "bool": {
      "must": [],
      "filter": [
        {
          "range": {
            "@timestamp": {
              "time_zone": "+07:00",
              "format": "yyyy-MM-dd HH:mm:ss.SSS",
              "gte": "2023-10-20 00:00:00.000",
              "lt": "2023-10-21 00:00:00.000"
            }
          }
        },
        {
          "exists": {
            "field": "http_status"
          }
        }
      ],
      "should": [],
      "must_not": []
    }
  }
}

Thanks

[jsanz (Jorge Sanz)]

Have you tried TSVB? It should support bucket aggregation as you are using here. Another option is to craft your own visualization using Vega.