The different num of Dashborad's show and table


(levi) #1

hi everyone,
I toke an dashborad for my table using kibana,I found the dashboard num different from table.here is my sql as bellows:

SELECT DISTINCT(t.amount) FROM v_achievement_budget t WHERE t.amount BETWEEN 0 and 10;
the count is 200.
the dashborad inclund metrics which was using the unique count of amount,and the from 0 to 10 num is 204. why the dashborad more than table? anyone can explain the diffarent,very appreciate.

Best Regards,
Levi


(Jon Budzenski) #2

Elasticsearch unique counts are an approximation, more details can be found at https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-cardinality-aggregation.html#_counts_are_approximate.

You can configure the precision_threshold in kibana by adding a JSON input:


(levi) #3

thanks for your quick response!


(system) #4