Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Count of days in week

Phil_H13
Level 2
Level 2

Hi.  I created a calculated metric to simply count the number of days using the approximate count distinct function.  It's been working just fine up until this past week.  Count shows 6 days in week instead of 7, even though a breakdown by day shows 7 days?  Any ideas why this is happening?

 

Count of days segment

Phil_H13_0-1595260886399.png

 

Report result:

Phil_H13_1-1595260948712.png

 

3 Replies
ishans52004352
Employee
Employee

Hi @Phil_H13 ,

The behavior looks weird. However, please note that the function Approximate Count Distinct isn't 100% accurate. The function uses the HyperLogLog (HLL) method of approximating distinct counts.  It is configured to guarantee the value is within 5% of the actual value 95% of the time.

Though, you may want to raise a ticket with us and we will happy to take a look.

Thanks!

mesood
Level 3
Level 3

This looks to be an issue and would request you to raise a ticket with Client Care