I am trying to show unique count in a metric and observed that the numbers are wrong.
I used enhanced table visualisation and did a "unique count" of keyword type field. in advanced setting I used
The filter used on top is of the format: field1.keyword:"value" AND field2:9*. I am getting a unique count of
However when I do terms aggregation and calculate the sum, it is showing
13678. I verified this number by downloading the csv and counting within excel.
The same issue occurs for metric type visualisation. Is there any setting which I am missing here or is this a product bug ?