nainaigu
nainaigu

Reputation: 147

Why unique count in kibana visualize chart is incorrect?

my kibana version is 4.5. my elastic version is 2.3.1.

see the pic1 .the uv is 7665. but see the pic2.the uv is 7845. why diffrent ? kibana unique count seeing not correct. pic1

pic2

Upvotes: 0

Views: 3483

Answers (1)

Kulasangar
Kulasangar

Reputation: 9444

If these charts are based on live data, then I doubt both the graphs cannot show the same count since you're having two different time-range in both the graphs.

In the first one your time range is yesterday, where as in the second one your trying to have an auto-refresh every minute which shows as paused. I'm assuming that you're dealing with live data so that some records might have slipped through, by the time you paused. If not I cannot see any chances of these two showing two different values.

Just being curious, how do you know that the correct count for uv should be 7665 since I can't see the exact value of uv from the snapshot of the graph? Did you double check from your ES indice through a query?

EDIT:

Interestingly Unique counts are based on the cardinality aggregation, which is designed to work efficiently across very large amounts of data and delivers an approximate result, which may why your results vary. You can maybe try increasing the precision_threshold.

To get a more correct value, add a something like: {"precision_threshold": 1000} to the "JSON Input" box for the aggregation.

Hope this helps!

Upvotes: 3

Related Questions