Count error in canvas

Elastic Stack Kibana
1

The values ​​aggregation from visualize and canvas are different.
The time was set equally.
Why is it so different?

metric(visualize)

image
image.png1234×544 41.5 KB

canvas

image
image.png1280×559 64.2 KB

2

Hello,
Using the TinyMath unique function in Canvas after retrieving the datasource will give you the number of unique values in the 1000(?) documents you get back from esdocs For canvas the equivalent of the Unique Count will be the COUNT_DISTINCT SQL command .

3

Can you explain in more detail?

my sql: SELECT DISTINCT COUNT(field_name) FROM "index_name"
image

4

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