What mean by the decimal point of SCI's "unique_users"?

hyomoon_kim — Tue, 04 Jan 2022 02:19:39 GMT

Hello,

Happy new year!

Our customer company is using SCI.

In the last month, I wanted to know the number of users, so I exported the data from Client -> Unique Clients Trend Over Time in the SCI menu as a CSV file.

The problem is that the unit of "unique_users" comes in decimal places.

As far as I know, it is the number of users.

So I understand that decimal places shouldn't come out.

Is it not the number of users?

May I know what it means to have a decimal point?

Thank you.

Re: What mean by the decimal point of SCI's "unique_users"?

see_ho_ting — Tue, 04 Jan 2022 03:20:27 GMT

Hi there,

Happy New Year!

As SCI is a big data system, it uses the hyperloglog algorithm to estimate the number of unique clients (with a typical error of 1% - 2%) as a tradeoff for query speed. As such, the raw output in the CSV file will have decimal places (in the SCI UI, we round it up to the nearest integer).

Hope this helps.

topic What mean by the decimal point of SCI's "unique_users"? in Smart Cell Insight (SCI)

What mean by the decimal point of SCI's "unique_users"?

Re: What mean by the decimal point of SCI's "unique_users"?