Counting number of days in a month

Avatar

Avatar
Level 1
rsbee
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
rsbee
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile
rsbee
Level 1

17-06-2020

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.

 

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Level 1
SJW_xio
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
SJW_xio
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile
SJW_xio
Level 1

15-06-2021

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