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

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 nonworking days within your calculations. Second, it simplifies your Period over Period calculations. I've done an extensive writeup of this in the past which you can find here: https://dojo.domo.com/main/discussion/53481/amoreflexiblewaytodoperiodoverperiodcomparisons#latest
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
 7.6K All Categories
 Connect
 913 Connectors
 241 Workbench
 470 Transform
 1.8K Magic ETL
 60 SQL DataFlows
 445 Datasets
 24 Visualize
 194 Beast Mode
 2K Charting
 6 Variables
 1 Automate
 348 APIs & Domo Developer
 82 Apps
 Workflows
 14 Predict
 3 Jupyter Workspaces
 11 R & Python Tiles
 241 Distribute
 59 Domo Everywhere
 241 Scheduled Reports
 14 Manage
 35 Governance & Security
 18 Product Ideas
 1.1K Ideas Exchange
 Community Forums
 15 Getting Started
 1 Community Member Introductions
 49 Community News
 18 Event Recordings
 579 日本支部