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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Count of Days Error

Avatar

Level 1

As you see my selected Time Frame is Feb 1 - Feb 23 and the count of days metric is showing 22. This happens very randomly and would like to know what causes this ? What is the best way to dynamically measure count of days besides the count distinct ?

vinayc16055999_0-1645792187945.pngvinayc16055999_1-1645792231782.png

 

 

3 Replies

Avatar

Level 2

Hi @vinayc16055999 ,

 

This calculated metric will give you the distinct number of days when your report suite had data. I believe in your case you are checking a report suite which has a different time zone than yours and actual day hasn't started in the report suite time zone.

Avatar

Level 1

Hi @kaush1889   I dont think its due to the reason specified as in the below snapshot you will see that the date range is Feb 1 - Feb 28  and no of days are 27

 

vinayc16055999_0-1646330009290.png

 

Avatar

Level 2

Pull a report with occurrences metric and Day as dimension. You will see that there is no data for one of the day in Feb.