Can I use a ETL or Beast mode to calculate starts and ends and show in a chart?
I have data showing the start and end date, such as the below. I want to use a chart to show starts & ends side by side by week. Is this doable with a ETL or beast mode?
CandidateName | CompanyName | StartDate | ActualEndDate |
|---|---|---|---|
Name1 | Company1 | 12/23/2024 | |
Name2 | Company2 | 12/23/2024 | |
Name3 | Company3 | 12/23/2024 | |
Name4 | Company4 | 12/23/2024 | |
Name16 | Company16 | 12/26/2024 | |
Name17 | Company17 | 12/26/2024 | |
Name18 | Company18 | 12/26/2024 | |
Name19 | Company19 | 12/26/2024 | |
Name20 | Company20 | 12/26/2024 | |
Name21 | Company21 | 12/26/2024 | |
Name22 | Company22 | 5/25/2024 | 12/22/2024 |
Name23 | Company23 | 5/25/2024 | 12/22/2024 |
Name24 | Company24 | 5/25/2024 | 12/22/2024 |
Name25 | Company25 | 5/25/2024 | 12/22/2024 |
Name26 | Company26 | 5/25/2024 | 12/22/2024 |
Name27 | Company27 | 5/25/2024 | 12/22/2024 |
Name28 | Company28 | 5/25/2024 | 12/22/2024 |
Name29 | Company29 | 5/25/2024 | 12/22/2024 |
Name30 | Company30 | 5/25/2024 | 12/22/2024 |
Name31 | Company31 | 5/25/2024 | 12/22/2024 |
The chart should look something like the below.
Best Answer
-
Yes you can accomplish this using Magic ETL.
Step 1: Split out your input data into two groups: Starts and Ends. Use two formula tiles.
Formula tile #1 (Starts) will look like this:
Formula tile #2 (Ends) will look like this:
Step 2: Append these groups together using the Append Rows tile:
Step 3: Use a filter tile to remove rows where the newly created `Date` field is null
Step 4: Create a card that is the Grouped Bar chart type. Use the newly created Date field as the Category, a count of the candidate name (or combination (concatenated) name that is both candidate + company, or some other unique identifier as the Value. And the newly created Group field as the series and voila!
Let me know if you get stuck or have any questions!
If I solved your problem, please select "yes" above
0
Answers
-
Yes you can accomplish this using Magic ETL.
Step 1: Split out your input data into two groups: Starts and Ends. Use two formula tiles.
Formula tile #1 (Starts) will look like this:
Formula tile #2 (Ends) will look like this:
Step 2: Append these groups together using the Append Rows tile:
Step 3: Use a filter tile to remove rows where the newly created `Date` field is null
Step 4: Create a card that is the Grouped Bar chart type. Use the newly created Date field as the Category, a count of the candidate name (or combination (concatenated) name that is both candidate + company, or some other unique identifier as the Value. And the newly created Group field as the series and voila!
Let me know if you get stuck or have any questions!
If I solved your problem, please select "yes" above
0 -
Thank you! I was going down the wrong path trying to use Group By or Dynamic Pivot. Thank you!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 627 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 755 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive