Creating a New column
Hi,
I am trying to figure out the easiest way to create a new column. The new column would be taking dates and assigning them to a month. For example the values assigned to NOV 2023 would be between Oct 27th(3 working days (excluding weekends) of the last month to Nov 27th (3 working days before the last day of the month. The values assigned to DEC would be Nov 28th to Dec 26th and so forth. I see you can add a date operation or new constraint but it doesn't give an option to select dates that are between certain dates. Any advice would be much appreciated.
Best Answers
-
@ColinHaze There are a couple different options you could use:
- You can reach out to your CSM about enabling a fiscal calendar in your instance. Here is a knowledge base article about how they work:
- You can upload a file to Domo with a row for every date and its corresponding month. Then you can join your data to that mapping table on date in MagicETL
1 -
I would suggest taking a look at the calendar dataset in the Domo Dimensions connector. You can use this calendar to dynamically get the last working day of each month. Then, you could use the formula tile to assign the month groupings based on a comparison of the calendar data and your data.
If I solved your problem, please select "yes" above
0
Answers
-
@ColinHaze There are a couple different options you could use:
- You can reach out to your CSM about enabling a fiscal calendar in your instance. Here is a knowledge base article about how they work:
- You can upload a file to Domo with a row for every date and its corresponding month. Then you can join your data to that mapping table on date in MagicETL
1 -
I would suggest taking a look at the calendar dataset in the Domo Dimensions connector. You can use this calendar to dynamically get the last working day of each month. Then, you could use the formula tile to assign the month groupings based on a comparison of the calendar data and your data.
If I solved your problem, please select "yes" above
0 -
To clarify you want to have a specific month be the last 3 working days of the last month until the last 3 working days of the specific month?
You have a couple of options:
1 - Create a custom date dimension where you assign each date to a specific month
2 - Use Magic ETL and a formula tile to calculate what month each date is a part of
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
GrantSmith Yes exactly , I am trying to use option 2 you mentioned. In the formula tile I assume I would use a case statement and then use between to get the dates then assign them to a month, correct?
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 303 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 105 SQL DataFlows
- 643 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 771 Beast Mode
- 74 App Studio
- 43 Variables
- 721 Automate
- 185 Apps
- 463 APIs & Domo Developer
- 59 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 402 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 135 Manage
- 132 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive