Expand my Community achievements bar.

Check out the November edition of the Analytics Community Lens newsletter to see what's been trending in the last two months!

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.