Show number as percentile in elasticsearch DSL

Elastic Stack Elasticsearch
1

Sample data

Name    response_code  
abc        6780
abc2       9999
abc3       1000
abc4       3456
.
.
.
abc20      9700

I want two perform following task

  1. Show those response_code whoes value is greater than 3000
  2. Show response_code as percentile for example 3000 is 30%

I performed something but don't how to perform percentile

{
  "query": {
    "range": {
      "response_code": {
        "gt": "3000"
      }
    }
  }
}
2

Percentile of what though?

3

if response code is 3456 it percentile would be 34.56%. I have to perform this operation on ML if it reached to more than 10 % it would be treated as an anamoly.

4

Why not alter that during ingestion, or add it on with a runtime field?

5

Hi @warkolm in kibana visualization we have response code value as percentage.
How to display data as a percentage in Kibana visualization

So i was thinking can we fetch those field either through KQL or normal query.

6

Except that percentage calculation is done by an aggregation, not being taken directly from the data like you want to do.

7

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