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.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive