# How to create a GAUGE using filter ratio
**URL:** https://discuss.elastic.co/t/how-to-create-a-gauge-using-filter-ratio/236689
**Category:** Kibana
**Created:** [June 11, 2020, 11:26am UTC](https://discuss.elastic.co/t/how-to-create-a-gauge-using-filter-ratio/236689 "2020-06-11T11:26:51Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@inchirah](https://discuss.elastic.co/u/inchirah)
#### Post date: [June 11, 2020, 11:26am UTC](https://discuss.elastic.co/t/how-to-create-a-gauge-using-filter-ratio/236689/1 "2020-06-11T11:26:51Z")
Hello @flash1293,
I took your advice and I used **TSVB**.
I tried to create **GAUGE** that showes the total **number of attempt** and the portion of **attempt compliant number**.
For that I used a **filter ratio** , but I didn't know how to used correctly.
This capture from my try.
And i want to get sthg similar to this:
Could you please help me.
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [June 12, 2020, 7:53am UTC](https://discuss.elastic.co/t/how-to-create-a-gauge-using-filter-ratio/236689/2 "2020-06-12T07:53:43Z")
I don't know where you got the syntax you are using (with `where`), but you should use Lucene in here. Try
- Numerator: `Constrainte:[-78 TO *]`
- Denominator: `*`
That should give you the ratio you are interested in. No need to work with `_id` here, as you are only after the count of documents matched by each query.
You can modify the styling in the "Panel options" tab.
---
### Author:  [@inchirah](https://discuss.elastic.co/u/inchirah)
#### Post date: [June 12, 2020, 10:13am UTC](https://discuss.elastic.co/t/how-to-create-a-gauge-using-filter-ratio/236689/3 "2020-06-12T10:13:28Z")
HI @flash1293
first thank's for help,
second i did what you told but i get 0 like below:
And about the picture tha t i told you i want sthg similar to it, i meant i want percentage of
attempt compliant number compared to the hole attempt number.
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [June 12, 2020, 11:12am UTC](https://discuss.elastic.co/t/how-to-create-a-gauge-using-filter-ratio/236689/4 "2020-06-12T11:12:25Z")
Remove the "Query string" - this is handled by the filter ratio.
You can change the number format, I think it's part of the "Options" tab.
---
### Author:  [@inchirah](https://discuss.elastic.co/u/inchirah)
#### Post date: [June 12, 2020, 12:13pm UTC](https://discuss.elastic.co/t/how-to-create-a-gauge-using-filter-ratio/236689/5 "2020-06-12T12:13:48Z")
I'm sorry but still dosen't work
that's capture from Data and Panel options
 
I couldn't figure out what's wrong.
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [June 12, 2020, 12:15pm UTC](https://discuss.elastic.co/t/how-to-create-a-gauge-using-filter-ratio/236689/6 "2020-06-12T12:15:51Z")
The numerator is wrong, please check my post from above.
---
### Author:  [@inchirah](https://discuss.elastic.co/u/inchirah)
#### Post date: [June 12, 2020, 12:43pm UTC](https://discuss.elastic.co/t/how-to-create-a-gauge-using-filter-ratio/236689/7 "2020-06-12T12:43:07Z")
Hey it works
but it gives me wrong number
The number of attempt compliant(Contrainte\>=-78) is 1638 from 2631 observations
So it should be 62.25%
---
### Author:  [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [June 12, 2020, 1:20pm UTC](https://discuss.elastic.co/t/how-to-create-a-gauge-using-filter-ratio/236689/8 "2020-06-12T13:20:18Z")
Things that could cause this:
- Wrong index pattern
- Time range does not include all documents
- "Data timerange mode" is not set to "Entire time range" in the Panel options
To make sure there are actually 1638 documents matching this query, go to discover, search for `Contrainte >= -78` and check the total hit count.
---
### Author:  [@inchirah](https://discuss.elastic.co/u/inchirah)
#### Post date: [June 12, 2020, 1:50pm UTC](https://discuss.elastic.co/t/how-to-create-a-gauge-using-filter-ratio/236689/9 "2020-06-12T13:50:40Z")
you're right it's my mistake
it works
thank you so much
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 10, 2020, 2:02pm UTC](https://discuss.elastic.co/t/how-to-create-a-gauge-using-filter-ratio/236689/10 "2020-07-10T14:02:11Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.