Date histogram does not work properly with unique count value

Elastic Stack Kibana
1

Hello,

I am using ELK 7.3 bar chart in kibana and did create unique count chart of value with date histogram but the when I use interval of monthly basis it skips one record in few months ,
Any idea guys how to resolve it

Thanks

2

Hey, can you show an example of this behavior?

  • Which documents do have in your index?
  • How is your chart configured exactly?
  • What are you expecting vs what is showed?

use interval of monthly basis it skips one record in few months

You mean you know the unique count of ips should be one higher?

3

image
image1853×556 28.2 KB

4

image
image399×523 18.4 KB

above is date histogram

5

I see, thanks. The unique count aggregation of Elasticsearch isn't always 100% accurate, trading precision for performance (see https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-cardinality-aggregation.html#_precision_control)

You should be able to control this trade-off by using the "Advanced > JSON input" setting:

{ "precision_threshold": 4000 }
6

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.