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
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 655 Datasets
- 114 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 770 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 76 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive