Hi! I have a very simple query that I need to make with a dashboard/visualization, but can't figure out how. I believe I need to use the visualization builder widget and filter ratios for this, but perhaps there is a better way.
Essentially I have an index/index pattern that has a certain field, like BusinessArea. And I want to see the ratio of this field being defined/not null over ALL records in that index. For example something like Field:BusinessArea not NULL or something, so I can get the % of records that have the field defined.
Anytime I try and do this I always end up with a 100%, which I know is not correct.
You can do this in TSVB in the Metric tab using the "Filter ratio" aggregation. Numerator and denominator are specified using Lucene syntax, so in your case the numerator should be _exists_:BusinessArea and the denominator should be *
Hi Joe, the second thing worked with the saved search. However using the numerator and denominator as indicated does not seem to work. Not sure if it's the syntax or what, but I tried both _exists:_ and exists:
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.