Creating kibana visualization

#1

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?

#2

If you are on Kibana 7.4.0 you can show the percentage of total in the Data Table. Then you could split the rows of the table on Ranges (0-100ms, 100-120ms, etc).

#3

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%
y-api 60% 10% 15% 10% 5%
z-api 50% 30% 5% 10% 5%

This is what is want.

Provided solution not giving me answer to my problem.

#4

You can split the table on api_name as well, in order to show the values for the other API.
Otherwise, regarding the percentages: there's 2 ways to display them, with the range or with the percentile ranks aggregation. What exactly do you need?

#5

I want range data

So i will say that, out of 100 x_api request,
50% completed in 100ms
20% completed in 120ms
15% completed in 150ms
10% completed in 400ms
5% completed in 1000ms
In a single table row.

#6

So this means that ranges will work. Otherwise if you split them by "under x ms" you'll see that values for 100ms for example would qualify for 120ms as well.