# Filter Ratio not displaying data
**URL:** https://discuss.elastic.co/t/filter-ratio-not-displaying-data/241490
**Category:** Kibana
**Created:** [July 16, 2020, 3:14pm UTC](https://discuss.elastic.co/t/filter-ratio-not-displaying-data/241490 "2020-07-16T15:14:21Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@franco-martin](https://discuss.elastic.co/u/franco-martin)
#### Post date: [July 16, 2020, 3:14pm UTC](https://discuss.elastic.co/t/filter-ratio-not-displaying-data/241490/1 "2020-07-16T15:14:21Z")
Hi, im indexing some data and I want to know the ratio of documents that have isCompliant as True. I visualized the data as count over time and I see documents.
Then I moved to gauge and applied the filter as grouping
But when I try to use filter ratio with the same filter as numerator, it stays at 0. Even when I choose \* as numerator and denominator it stays at 0. (Shouldnt it be 1?)
---
### Author:  [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [July 16, 2020, 3:38pm UTC](https://discuss.elastic.co/t/filter-ratio-not-displaying-data/241490/2 "2020-07-16T15:38:23Z")
Unless you set the "Time range mode" in TSVB to "entire time range", you will only see the _last time interval_ in gauges. Since your visualization says the interval is 10 minutes, you will only see the last 10 minutes in the gauge.
---
### Author:  [@franco-martin](https://discuss.elastic.co/u/franco-martin)
#### Post date: [July 16, 2020, 3:52pm UTC](https://discuss.elastic.co/t/filter-ratio-not-displaying-data/241490/3 "2020-07-16T15:52:15Z")
It is set to entire time range. WHat you see as 10 minutes is the time aggregation
---
### Author:  [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [July 16, 2020, 4:08pm UTC](https://discuss.elastic.co/t/filter-ratio-not-displaying-data/241490/4 "2020-07-16T16:08:34Z")
Okay. It is important to note that [Filter Ratio does not use KQL syntax](https://github.com/elastic/kibana/issues/67503), it uses Lucene syntax. They are similar but not identical. If your field is a boolean, then you need to use `isCompliant: true` instead of `isCompliant: True`.
If that doesn't solve the issue, then it would be helpful to see an example document that you are trying to match against.
---
### Author:  [@franco-martin](https://discuss.elastic.co/u/franco-martin)
#### Post date: [July 16, 2020, 5:09pm UTC](https://discuss.elastic.co/t/filter-ratio-not-displaying-data/241490/5 "2020-07-16T17:09:22Z")
The field is not boolean, it has three possible values for now. True, False and nopipeline. I tried the same query with a boolean field and the query syntax as suggested but it is still not working.
 
Here are the values that field can take
Finally, here is a sample document.
```
"@timestamp": "2020-07-16T03:25:35.254747",
"tags-key-value": {},
"languages": {},
"isCompliant": "nopipeline"
```
---
### Author:  [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [July 16, 2020, 5:27pm UTC](https://discuss.elastic.co/t/filter-ratio-not-displaying-data/241490/6 "2020-07-16T17:27:38Z")
Got it. Then this should be working. Are you sure you've enabled "Entire time range mode" in TSVB? It wasn't in any of the screenshots.
---
### Author:  [@franco-martin](https://discuss.elastic.co/u/franco-martin)
#### Post date: [July 16, 2020, 5:40pm UTC](https://discuss.elastic.co/t/filter-ratio-not-displaying-data/241490/7 "2020-07-16T17:40:25Z")
Yeah, here you go
---
### Author:  [@franco-martin](https://discuss.elastic.co/u/franco-martin)
#### Post date: [July 16, 2020, 6:55pm UTC](https://discuss.elastic.co/t/filter-ratio-not-displaying-data/241490/8 "2020-07-16T18:55:37Z")
I updated kibana from opendistro 1.8 to 1.9 and it didnt fix it. What I did was remove the wildcards.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 13, 2020, 6:55pm UTC](https://discuss.elastic.co/t/filter-ratio-not-displaying-data/241490/9 "2020-08-13T18:55:38Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.