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

Brendon

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 :).

GrantSmith

Hi @brandon_johnson@Brendon

I'd recommend using a new date dimension dataset to solve a few of your problems. First, you can mark which fields are considered working days within your dimension dataset which would allow you to then include or exclude non-working days within your calculations. Second, it simplifies your Period over Period calculations. I've done an extensive write-up of this in the past which you can find here: https://dojo.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest