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

Counting number of days in a month

rsbee
Level 1
Level 1

Hey guys,

I'm trying to calculate the total number of days in a month. I used the Approximate Count Distinct Function but the counts are inaccurate (April has 29 days even though all the dates recorded a lot of data).

The end goal is to calculate Average Daily Hours Spent at a Monthly level. I'm hoping that once I can count the number of days in a month, I can use the below formula.

Pull by Month

=(Total Seconds Spent/3600)/Days in a month

 

Any help is appreciated as I'm new to this. Thank you very much.

 

1 Reply
SJW_xio
Level 1
Level 1

I had the same problem when calculating a weekly average for a time period with incomplete weeks.
It seemed the count of days was out by one, so I added this within the formula which made it exact

SJW_xio_0-1623772776298.png