Count of days in week

Avatar

Avatar
Level 1
Phil_H13
Level 1

Likes

0 likes

Total Posts

7 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
Phil_H13
Level 1

Likes

0 likes

Total Posts

7 posts

Correct reply

0 solutions
View profile
Phil_H13
Level 1

20-07-2020

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

 

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar
Boost 5
Level 2
mesood
Level 2

Likes

16 likes

Total Posts

51 posts

Correct reply

5 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Affirm 5
View profile

Avatar
Boost 5
Level 2
mesood
Level 2

Likes

16 likes

Total Posts

51 posts

Correct reply

5 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Affirm 5
View profile
mesood
Level 2

21-07-2020

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

Avatar

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

154 likes

Total Posts

324 posts

Correct reply

104 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

154 likes

Total Posts

324 posts

Correct reply

104 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
ishans52004352
Employee

20-07-2020

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!