Hi,
I have an elastic search index, which has a time field which is java API response time in milliseconds.
Now i want to create a kibana data table visualization that will show api response time in diff bucket as follows :
Table 1:
api_name (% of api taking 100ms) (% of api taking 120ms) (% of api taking 150ms) (% of api taking 400ms) (% of api taking 1000ms) |
---|
x-api 50% 20% 15% 10% 5% |
I have tried using Percentile Ranks Aggregation, but will add all previous data also, that i don't want. :
Table 2:
api_name (% of api taking 100ms) (% of api taking 120ms) (% of api taking 150ms) (% of api taking 400ms) (% of api taking 1000ms) |
---|
x-api 50% 70% 85% 95% 100% |
So how I able to create Table -1 using kibana visualization?