I need to calculate the percentage for a null values present in a column w.r.t to unique ids present in another column and not based on record counts.
I tried the percentage in Table and Pie chart but they are quiet miss leading.
Can someone help with how this can be done in TSVB Filter Ratio or whether I've done it correctly?
Have set the Data Formatter to Percent.
TSVB uses the Query String syntax, so I think that might be your issue: https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-query-string-query.html#query-string-syntax
The other setting that might be relevant is the time range- you should try setting the TSVB range to Entire time range instead of Last value only.
Thank you @wylie. I have set the date to Entire Time Range and the filter ratio by entering values as shown in the above picture. 
Did you change the query based on the syntax documentation I sent above?
No @wylie, I filled the numerator, denominator and metric aggregation as shown in the first image. I was able to get the right percentage as shown below.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
© 2020. All Rights Reserved - Elasticsearch
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.
