# Filter Ratio issues

**URL:** https://discuss.elastic.co/t/filter-ratio-issues/235304
**Category:** Kibana
**Created:** [June 2, 2020, 9:33am UTC](https://discuss.elastic.co/t/filter-ratio-issues/235304 "2020-06-02T09:33:28Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![spaolik](https://avatars.discourse-cdn.com/v4/letter/s/e0b2c6/32.png) [@spaolik](https://discuss.elastic.co/u/spaolik)
#### Post date: [June 2, 2020, 9:33am UTC](https://discuss.elastic.co/t/filter-ratio-issues/235304/1 "2020-06-02T09:33:29Z")

</div>

Hello,

I'm using Kibana 7.5.2 and I'm facing some issues using the Filter Ratio.  
WHat I'm trying to achieve is to have 2 bars in a time series, showing Total number of Partners vs Total number of "interested" partners (tagged with a specific "Interested" flag.  
On top of the 2 bars I'd like to show the "percentage" line of interested vs total, evolving in time.  
Issues faced:

1. Time series shows 2 bars one besides the other only when not adding a new metric for the percentage. Once the new "Percentage" metric is added, the bars are stacked even though "None" is selected in the Chart type. -\> is this a known bug?
2. The "percentage" calculated by Kibana seems totally off, I cannot figure out what I'm doing wrong. But if I have 13 Active Partners and 3 Interested Partners I dont understand how Percentage can be 100%. -\> What am I missing?  
 ![FilterRatio_01](https://us1.discourse-cdn.com/elastic/original/3X/3/9/3943646adabddf8e67f68fa8b932da2bab4e8b11.png) ![FilterRatio_02](https://us1.discourse-cdn.com/elastic/original/3X/b/c/bc534702962580d611adbf1101e9a3035e84a356.png)  
Thanks a lot  
Stefania Paolik  
Thales Services FR

---

<div class="post-metadata">

### Author: ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)
#### Post date: [June 3, 2020, 3:04pm UTC](https://discuss.elastic.co/t/filter-ratio-issues/235304/2 "2020-06-03T15:04:13Z")

</div>

Here is a blog post that helps explain how to display percentages

> **[How to display data as a percentage in Kibana visualizations](https://www.elastic.co/blog/how-to-display-data-as-a-percentage-in-kibana-visualizations)**
>
> Using percentages in data analytics is essential for effective numeric comparison, especially when working with drastically different sample sizes or totals. Find out how to calculate percentages in Kibana with common visualizations, including a pie...

---

<div class="post-metadata">

### Author: ![spaolik](https://avatars.discourse-cdn.com/v4/letter/s/e0b2c6/32.png) [@spaolik](https://discuss.elastic.co/u/spaolik)
#### Post date: [June 4, 2020, 1:29pm UTC](https://discuss.elastic.co/t/filter-ratio-issues/235304/3 "2020-06-04T13:29:44Z")

</div>

Hi,

thanks, I had already seen this page, but it doent answer to all my points.  
I really need side by side bars, and not stacked. I cant seem to get the side by side when using filters. Is this a bug?

Also, how is Filter Ratio calculate the percentage? if I have A (unique count of partners for month of may)=80 and B(unique count of interested partners for month of may)=10 and I have A as denominator and B as nominator, I expect to have a resulting ratio percentage of 12,5%. I get 100% today. I dont understand.

Rgds  
Stefania Paolik

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 2, 2020, 1:29pm UTC](https://discuss.elastic.co/t/filter-ratio-issues/235304/4 "2020-07-02T13:29:44Z")

</div>

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