# Creating kibana visualization
**URL:** https://discuss.elastic.co/t/creating-kibana-visualization/202017
**Category:** Kibana
**Created:** [October 2, 2019, 5:15pm UTC](https://discuss.elastic.co/t/creating-kibana-visualization/202017 "2019-10-02T17:15:19Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@pksinghal](https://discuss.elastic.co/u/pksinghal)
#### Post date: [October 2, 2019, 5:15pm UTC](https://discuss.elastic.co/t/creating-kibana-visualization/202017/1 "2019-10-02T17:15:20Z")
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?
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [October 4, 2019, 11:01am UTC](https://discuss.elastic.co/t/creating-kibana-visualization/202017/2 "2019-10-04T11:01:34Z")
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).
>
---
### Author:  [@pksinghal](https://discuss.elastic.co/u/pksinghal)
#### Post date: [October 4, 2019, 11:46am UTC](https://discuss.elastic.co/t/creating-kibana-visualization/202017/3 "2019-10-04T11:46:11Z")
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.
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [October 4, 2019, 12:40pm UTC](https://discuss.elastic.co/t/creating-kibana-visualization/202017/4 "2019-10-04T12:40:51Z")
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?
---
### Author:  [@pksinghal](https://discuss.elastic.co/u/pksinghal)
#### Post date: [October 4, 2019, 6:43pm UTC](https://discuss.elastic.co/t/creating-kibana-visualization/202017/5 "2019-10-04T18:43:42Z")
I want range data
> [@Marius\_Dragomir](#):
>
> with the range
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.
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [October 11, 2019, 12:35pm UTC](https://discuss.elastic.co/t/creating-kibana-visualization/202017/6 "2019-10-11T12:35:46Z")
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.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [November 8, 2019, 12:35pm UTC](https://discuss.elastic.co/t/creating-kibana-visualization/202017/7 "2019-11-08T12:35:52Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.