Visualize Elastic Query

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

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

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.