Combining outputs from 4 different cards and 4 datasets I don't want to join together
Hello,
Hoping there's an easy answer to this.
I have 4 different cards coming from 4 different datasets with no common fields. So I don't want to join them together.
The 4 cards created are 1 number cards showing a dollar calculation (let's call it "profit").
Card #1: Profit from Sales ($100)
Card #2: Profit from Operations ($200)
Card #3: Profit from Investments ($300)
Card #4: Profit from Services ($400)
I would like to create a fifth card that shows the total of the 4 cards above added together.
Is there a way to export the values from each card so I can then add them together in a fifth summary card?
Maybe the way to do this is to manipulate the datasets in ETL before -- although I am not well versed in creating complex ETL yet...
Thanks. James
Best Answer
-
If the numbers you want to combine are each in different datasets, then you will need to use Magic ETL to bring them together. You would add all 4 of your datasets as input datasets in Magic ETL and then use the Append Rows tile to bring them all together and choose the option to include all columns. Add your output dataset and then build your card off this newly created dataset.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
If the numbers you want to combine are each in different datasets, then you will need to use Magic ETL to bring them together. You would add all 4 of your datasets as input datasets in Magic ETL and then use the Append Rows tile to bring them all together and choose the option to include all columns. Add your output dataset and then build your card off this newly created dataset.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Thanks Mark, that's what I thought I'd have to do.
1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 113 SQL DataFlows
- 651 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 795 Beast Mode
- 78 App Studio
- 44 Variables
- 755 Automate
- 187 Apps
- 480 APIs & Domo Developer
- 71 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 407 Distribute
- 118 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive