Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

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.