As I been exploring the use of ES|QL , I found inconsistencies with metric visualizations using unique count. I have a dataset with 6,929 unique host.name values and for the sake of this it will only show up as 6,929 documents. So I did every metric visualization and was surprised to find the difference in values:
Hey @Marco_Liberati ,
thanks, I been using Unique count for a while and didn't know it was an approximate. This is very shocking as we have used unique count in Lens all throughout our dashboards. Depending on the level of cardinality, it seems we are providing inaccurate numbers.
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.