# Display a ratio of data
**URL:** https://discuss.elastic.co/t/display-a-ratio-of-data/265449
**Category:** Kibana
**Tags:** lens
**Created:** [February 25, 2021, 8:11am UTC](https://discuss.elastic.co/t/display-a-ratio-of-data/265449 "2021-02-25T08:11:53Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@jazzdorf](https://discuss.elastic.co/u/jazzdorf)
#### Post date: [February 25, 2021, 8:11am UTC](https://discuss.elastic.co/t/display-a-ratio-of-data/265449/1 "2021-02-25T08:11:53Z")
Hi guys,
I have some difficulties with Kibana.
My data contains IDs and links:
```auto
{
"_index": "debug_sample_data",
"_type": "_doc",
"_id": "rPeEz3cBYzpkMbM6YKCc",
"_version": 1,
"_score": null,
"_source": {
"datum": "2021-02-23",
"id": "Egomotion_D_633",
"links": [
{
"id": "Egomotion_D_Link_0"
},
{
"id": "Egomotion_D_Link_1"
}
]
},
"fields": {
"datum": [
"2021-02-23T00:00:00.000Z"
]
},
"highlight": {
"id": [
"@kibana-highlighted-field@Egomotion_D_633@/kibana-highlighted-field@"
]
},
"sort": [
1614038400000
]
}
```
Now I want a Pie chart or something similar, where 100% is my count of IDs. and X% is my number of IDs that have links.
Is there a way I can achieve that with Kibana?
The queries I'm using for
- number of ids:
id: _Egomotion_
- number of ids with links:
id: _Egomotion_ and links.id: \*
Thanks in advance. I couldn't find any solution so far.
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [February 25, 2021, 10:50am UTC](https://discuss.elastic.co/t/display-a-ratio-of-data/265449/2 "2021-02-25T10:50:41Z")
You should be able to do this using the "filters" function.
For the "Size by" dimension, use the "Unique count of id" function, for the "slice by" dimension, use a filters function with these filters:
`NOT links.id: *`
`links.id: *`
---
### Author:  [@jazzdorf](https://discuss.elastic.co/u/jazzdorf)
#### Post date: [February 25, 2021, 3:02pm UTC](https://discuss.elastic.co/t/display-a-ratio-of-data/265449/3 "2021-02-25T15:02:15Z")
Great! Thanks flash1293!
Seems to work!
Is it possible to display the number as percentage in the middel of the donut?
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [February 25, 2021, 4:08pm UTC](https://discuss.elastic.co/t/display-a-ratio-of-data/265449/4 "2021-02-25T16:08:17Z")
There's no way to show a number in the donut hole, but the number should be shown in the slices as percentage like this, right?
---
### Author:  [@jazzdorf](https://discuss.elastic.co/u/jazzdorf)
#### Post date: [February 25, 2021, 4:16pm UTC](https://discuss.elastic.co/t/display-a-ratio-of-data/265449/5 "2021-02-25T16:16:51Z")
Unfortunanetly, it doesn't. Although I have "Show values" siwtched on in the Options tab.
Only when I hover over it with the cursor.
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [February 25, 2021, 4:18pm UTC](https://discuss.elastic.co/t/display-a-ratio-of-data/265449/6 "2021-02-25T16:18:53Z")
Can you make a screenshot of your visualization? Which browser and which version of Kibana do you use?
---
### Author:  [@jazzdorf](https://discuss.elastic.co/u/jazzdorf)
#### Post date: [February 25, 2021, 4:25pm UTC](https://discuss.elastic.co/t/display-a-ratio-of-data/265449/7 "2021-02-25T16:25:45Z")
Sure.
I'm using Chrome.
Version is 7.8.0 I think.
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [February 25, 2021, 4:37pm UTC](https://discuss.elastic.co/t/display-a-ratio-of-data/265449/8 "2021-02-25T16:37:13Z")
You can enable "Show labels" then it will look like this:
The screenshot I did is from Kibana \>7.10 - by using the Lens visualization you can get a much better looking pie chart.
---
### Author:  [@jazzdorf](https://discuss.elastic.co/u/jazzdorf)
#### Post date: [February 25, 2021, 8:34pm UTC](https://discuss.elastic.co/t/display-a-ratio-of-data/265449/9 "2021-02-25T20:34:34Z")
To be honest, I can't really figure out how to produce this donut chart with the lens visualization. Any suggestions would be appreciated!
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [February 26, 2021, 1:01pm UTC](https://discuss.elastic.co/t/display-a-ratio-of-data/265449/10 "2021-02-26T13:01:03Z")
As I mentioned, you need Kibana \>=7.10 for that. In 7.8 the Filters aggregation is not supported.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 26, 2021, 1:01pm UTC](https://discuss.elastic.co/t/display-a-ratio-of-data/265449/11 "2021-03-26T13:01:05Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.