How to use a beastmode to divide X from the same time period between 2 years.

Hello,

I have an 'hours' worked column broken out by work date in my dataset. I'd like to be able to sum the hours worked so far this year, and divide them by the sum of hours in the same time period last year. For example, summing the hours from Jan 1st, 2023 - Current Day and dividing it by the sum of the hours from Jan 1st, 2022 - (Current Day - 1 year).

The goal is to compare hours worked YTD or monthly to each other - it would be extra awesome if we could make it account for the number of working days completed so far in the month / year.

Really appreciate any insights on this and thanks for taking the time to read or respond if you see this :).

Tagged:

Comments