Easy Way to Measure Time in Business Days?
Best Answers
-
Lucas,
There is an action in Magic ETL that can help you determine the difference between two dates in working days (weekdays). Use the Date Operations tile, selet "Difference between dates" as the operation, and then "Working days" as the unit of measurement.
If you need a more advanced way of handling this that would include holidays or a custom schedule, it is a fairly complex setup. Most people use a calendar dataset to help with that. They can then run a subselect in a SQL query to count the days between the start and end that have appropriate features (is a workday, isn't a holiday, etc.). It isn't speedy, but it can work.
2 -
One thing we've done to help in this regard is to add business day columns to affected datasets. We have a separate calendar dataset that includes, for each day, what business day of the month, quarter, and week each day is. We combine that data into our other, transactional data. Then it's a simple math operation to find out how many business days, for example, are between Mar 17th and Nov 4th.
Going the opposite way, like finding the 20th business day ago from today, that's harder to do.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Answers
-
Lucas,
There is an action in Magic ETL that can help you determine the difference between two dates in working days (weekdays). Use the Date Operations tile, selet "Difference between dates" as the operation, and then "Working days" as the unit of measurement.
If you need a more advanced way of handling this that would include holidays or a custom schedule, it is a fairly complex setup. Most people use a calendar dataset to help with that. They can then run a subselect in a SQL query to count the days between the start and end that have appropriate features (is a workday, isn't a holiday, etc.). It isn't speedy, but it can work.
2 -
One thing we've done to help in this regard is to add business day columns to affected datasets. We have a separate calendar dataset that includes, for each day, what business day of the month, quarter, and week each day is. We combine that data into our other, transactional data. Then it's a simple math operation to find out how many business days, for example, are between Mar 17th and Nov 4th.
Going the opposite way, like finding the 20th business day ago from today, that's harder to do.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive