Unique count: Any alternative?

OpenSearch Dashboards
1

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser): 2.4.1

Describe the issue:
I have more then 100k documents like this:

APPLICATION_ID;DATE;SCORE
APP-1;2023-01-03;15
APP-2;2023-01-03;12
APP-3;2023-01-03;16
APP-1;2023-01-04;21
APP-2;2023-01-04;27

I would like to create a table with 2 columns like this:
column 1: Score Ranges
column 2: Distinct Count of APPLICATION_ID

So, something like this:

image

But I just read the count distinct is approximate. Any Idea how to see the exact count?

Thanks!
Salvo

2

Hi @SalvoDiMa91

My understanding is that you have an index with that three fields. If that is the case I would create a viz with a enhanced table with the following parameters:

  • metric: unique count of application_id field
  • bucket: split rows by “range”

Regarding the accuracy my experience is that you will not have issues if the index is small. I know using “small” is something not that trivial because we would need to compare the size of the index (shards) with the memory of the machines.

At least in older elasticsearch/kibana version it was possible to tune the precision threshold.

My 2 cents.