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. [over time] Then I moved to gauge and applied the filter as grouping [asCount with filter] But when I try to use filter ratio with the s…

I updated kibana from opendistro 1.8 to 1.9 and it didnt fix it. What I did was remove the wildcards. [nonwildcard]

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.

It is set to entire time range. WHat you see as 10 minutes is the time aggregation

Okay. It is important to note that Filter Ratio does not use KQL syntax , 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 ex…

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. [empty repo as ratio] [empty repo as group] Here are the values that field can take [values compli…

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.

Discuss the Elastic Stack

Filter Ratio not displaying data

Elastic Stack Kibana

franco-martin (Franco Martin) July 16, 2020, 5:40pm 7

Yeah, here you go

Topic		Replies	Views
How to create a GAUGE using filter ratio Kibana	9	1725	July 10, 2020
Visualize: Divide values of 2 filters Kibana	4	9272	December 1, 2017
Kibana TSVB - Percentage of Samples crossing Threshold Filter Ratio Always Returning 0 for one Index Kibana visualisation	5	726	July 4, 2023
TSVB Aggregation filter Kibana	6	1427	July 27, 2021
Creating a visualization that uses filter ratios to see utilization rate of a certain field Kibana	6	724	July 14, 2020

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Filter Ratio not displaying data

Related topics