Date histogram does not work properly with unique count value

[Abdul_Rahman]

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

[flash1293 (Joe Reuter)]

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?

[Abdul_Rahman]

[Abdul_Rahman]

above is date histogram

[flash1293 (Joe Reuter)]

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 }