Help with which Action Tiles To Use
Hi all!
I'm back with more beginner level questions probably :)
I feel like I've done the complex piece for this which is writing 24 different Beast Modes. I'm just struggling with which Actions to use in the ETL to bring all these Beast Modes together at once.
This looks like a fairly useless mockup because there's no values in it, and it's heavily simplified, but let me explain. The input table has one row per project. In the output, I need to SUM these based on my Beast Modes for all projects, but each row in the output - in fact, each cell - needs a different Beast Mode using other columns from the Input in their calculation (not shown).
Technically, the output is what I need my Card to look like, but I think the Dataset can look the same.
Just as an example of what I'm talking about, for the first row in the Output, Baseline, these are my three different Beast Modes
2024 CAPEX
SUM(CASE WHENRecordType
= 'Live' AND YEAR(Month
)=2024 ANDFinancialCategoryName
LIKE '%CAPEX%' THENPlannedCost
ELSE 0
END)
2024 OPEX
SUM(CASE WHENRecordType
= 'Live' AND YEAR(Month
)=2024 ANDFinancialCategoryName
LIKE '%OPEX%' THENPlannedCost
ELSE 0
END)
2024 Run Cost
MAX(CASE
WHENRecordType
= 'Live' ANDFirst Year of Impact_p
='2024' THENYearly Total RUN Costs (CHF)_p
WHENRecordType
= 'Live' ANDFirst Year of Impact_p
IS NULL THENYearly Total RUN Costs (CHF)_p
ELSE 0
END)
So that's just one row of the output, and then each subsequent row has a different formula per cell.
How do I bring it all together into a single table? Just struggling with which Actions to use and in what order. Thanks!
Best Answer
-
From your screenshots I'm assuming you have three formulas for each of five rows, that's where the numbers below are coming from.
Start with an Input DataSet tile. We'll split that tile's output out to five Add Constants tiles, where we'll add a column called "Row Name" to each, with values "Baseline", "Rejected", "On-Hold", etc.
After each Add Constants comes a Group By, which uses "Row Name" as its grouping column. Each Group By gets three formula aggregates, which are the three formulas that correspond to the relevant Row Name for that path.
Finally, we'll use an Append Rows tile to combine the rows together into one table. Since all the paths have the same column names, it shouldn't matter how you configure that tile.Randall Oveson <randall.oveson@domo.com>
0
Answers
-
From your screenshots I'm assuming you have three formulas for each of five rows, that's where the numbers below are coming from.
Start with an Input DataSet tile. We'll split that tile's output out to five Add Constants tiles, where we'll add a column called "Row Name" to each, with values "Baseline", "Rejected", "On-Hold", etc.
After each Add Constants comes a Group By, which uses "Row Name" as its grouping column. Each Group By gets three formula aggregates, which are the three formulas that correspond to the relevant Row Name for that path.
Finally, we'll use an Append Rows tile to combine the rows together into one table. Since all the paths have the same column names, it shouldn't matter how you configure that tile.Randall Oveson <randall.oveson@domo.com>
0 -
Hi Randall,
Just finally having a moment to come back to this today. Thank you for your help on yet another topic! I think I have it working, but it's potentially highlighting some issues with my Beast Mode that I will look into separately & validate. Just to confirm this is how I set up each of the Appends? Configuration for first one shown, and I just added two of them for now.
0 -
That looks right to me.
Randall Oveson <randall.oveson@domo.com>
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive