How can I get the data from several feeder cards to populate a master card?

charles · 2022-04-15T22:21:59+00:00

There was an error rendering this rich post.

Hello. I have built a page in DOMO that has several cards. Most of the cards are filter cards, but some display the data in tables based on the filters from their associated filter cards. There is also 1 master card that is supposed to accumulate all the data from the different table cards on the same page. I can get any one of the feeder table cards to populate the master card, but not more than one at a time. The data from the [feeder] table cards needs to be added to the data from the other feeder table cards in the master card, and NOT replaced to only reflect the data from one feeder table card at a time. How can I get multiple cards to populate their individual data into a main card?

Quick Links

Accepted answers

All comments

charles

MarkSnodgrass

I would consider creating a Magic ETL that appends all your datasets together into a single dataset that would be used for all your cards on this page. You can add a constant for each dataset before appending to make it easy for you to create the card for each of your "feeder" cards because you can use that constant as a filter behind the scenes on the card to have it display that specific dataset, while still being from a single dataset that all the cards are using. Your ETL would look something like this:

This will make designing and managing your page much easier and allow your "master" card to function as you are hoping.

Hope this helps.

charles

Hello Mark. Thanks for responding. As far as the data flows, all the the cards are built from the same data set. Does that make a difference with regards to your suggested data flow? Also, the point of the append card is so the page user can change the filters as needed and then easily download the append card data into an excel spreadsheet.

charles

Mark, as a follow up comment, I should note, the relationships of the cards in the picture are important as they determine how the data is produced in the various red data cards. Card 1 and card 2 filter for and produce the data in card 3. Card 1 only affects the filters in card 2. Card 2 affects the data in card 3 and the filter in card 4. Card 3 is only meant as a repository for the first line of filters (cards 1 & 2) and is the first compilation of data to be dumped into the append card. A one time filter for marketing, parts, and orgs will not produce the desired results. Every time a user chooses filters from the first 2 filters in each row of cards, it affects the filters in the following row and produces specific data that needs to be captured. The next row of filters produces specific data that needs to be captured and also affects the filters in the following row. After speaking with our resident DOMO expert, he believes your earlier suggestion will not produce the desired results, and since all the cards are coming from the same data set, we don't think the data flow needs to be changed. Please correct me if we are mistaken. That said, is it possible to simply append the data from each of the data cards (cards 3, 6, & 9) into the append card?

MarkSnodgrass

All appending is done in dataflows, not in cards. When you say that all cards are coming from the same dataset, is that just the same origin, or they are all actual powered by the same dataset? You can tell by editing a card, and looking at the dataset name on the left side above the dimensions and measures. If all 10 cards show the same dataset name, then it is just a matter of setting the correct interaction settings on the append card.

charles

All 10 the cards are actually powered by the same data set. How could I change the interaction settings on the append card so the other cards will not further refine/filter the data in the append card, but add the data from each feeder/data card?

MarkSnodgrass

When no filters are selected on your dashboard, your append card should be showing all your data. If it isn't, you need to see what filters are set on it in Analyzer that are keeping it from showing everything.

Then, edit your dashboard and choose Edit Content on each of your filter cards and choose Change Interaction. Change it from Apply to all Cards on Dashboard to Apply to selected cards and choose the appropriate cards they should interact with. For example, Card 1 filter should interact with Card 2 filter, Card 3 data and the Append Card.

charles

Yes, correct, when no filters have been selected, all of the data is showing up in the append card. I already modified the interactions between the various cards so that they only interact with other specific cards (as depicted by the black arrows in the picture above). They work fine until the data is to be loaded into the append card, then it seems that instead of adding the new data from each row, it refines the data from the previous row, until the append card is without any data.

MarkSnodgrass

Are cards 2, 5, and 8 showing values from the same column? Or different columns?

charles

I renamed the each one of the columns so the data would not change from row to row, however, they are all showing the same data from the same data set, only the column was renamed in a beast mode for the successive cards.

MarkSnodgrass

I think I'm starting to wrap my head around what you have set up. Let's use part_number as an example.

If cards 2, 5, and 8 each use the column part_number, then selecting 1 part on each of those cards should result in 3 rows showing on your append card. This is assuming you don't select any filters on cards 1, 4, and 7.

If that works successfully, then I think your answer is to make sure the column names are the same and not renamed as beast modes. Secondly, only let cards 2, 5 and 8 interact with the append card. Cards 1, 4, and 7 should not interact with the append card directly as it result in additional AND statements, which is why you lose rows.

Hopefully, this does the trick for you.

charles

Your comment from above---"If cards 2, 5, and 8 each use the column part_number, then selecting 1 part on each of those cards should result in 3 rows showing on your append card." This does not happen. Selecting a part number from card2 correctly populates the append card.

However, when I select another part number from card5, the data in the append card is replaced, and the card2 filter is unselected...,

..., even though neither card2 nor card5 interact with each other. The following is the interactions for card2:

MarkSnodgrass

It looks like what you want to happen, is not possible. I just put together a test dashboard and running into the same issue. It treats the filters as one or the other and doesn't let you use them both when they are the same column.

I would give some thought to a different approach. You might just need to have cards 2, 5 and 8 be stacked so they appear together, but they are separate cards.

charles

Yeah, I was afraid of that. Stacking the cards won't have the desired results either. The goal is to make it so all the data is compiled in 1 place so the user can easily download the data to excel. Thank you for your help and patience. You are correct that we will need to come up with a different approach. Thanks again.

other categories

Product Ideas
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ideas Exchange
Suggest & vote on new features you would like to see implemented in the Domo Product.
Data Connections
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Connectors
Connectors, Custom Connectors, Writeback
Workbench
Ask questions about Workbench, a secure, client-side solution for uploading your on-premise data to Domo.
Cloud Integrations
Ask questions about Cloud Integrations and Federated Data connection to your data warehouse or lake.
Data & ETL
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Magic ETL
Ask Magic ETL questions and get answers from Domo peers
SQL DataFlows
Ask SQL DataFlow questions and get answers from Domo peers
Datasets
Ask DataFusion and Dataset Views questions and get answers from Domo peers
Visualize & Apps
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Dashboards
Ask Cards, Dashboards, and Stories questions and get answers from Domo peers
App Studio
Ask questions about building apps in App Studio.
Pro-code Components
Ask questions about pro-code components and Domo Bricks and get answers from Domo peers.
Charting & Analyzer
Ask questions about charting and Analyzer and get answers from Domo peers.
Calculations & Variables (Beast Mode)
Ask questions about using calculated fields and Variables (Beast Modes) in Analyzer.
AI & Data science
Ask questions about DomoAI and get answers from Domo peers.
Domo AI & AI Chat
Ask questions about AI Chat and AI assistants.
Managing AI
Ask questions about managing AI with AI Playground, AI projects, AI models, and more.
Jupyter Workspaces
Ask questions about Jupyter Workspaces, Notebooks, and file share.
Automate
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Workflows
Ask questions about Task Center, building automations with Domo Workflows, and executing JavaScript or Python code with Code Engine.
Alerts
Ask questions about managing alerts in Domo and get answers from Domo peers.
Distribute
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Domo Everywhere
Ask questions about embedded analytics with Domo Everywhere.
Reporting
Ask questions about Scheduled Reports, Report Builder, and Slideshow Publications.
Manage
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Governance & Security
Ask questions about People, Groups, Roles, Sandbox, Activity log, Buzz, Teams, Approvals and PDP and get best practices from Domo peers
Navigation & Productivity
Ask questions about navigation, Projects & Tasks, Goals, and Buzz chat.
APIs
Ask APIs and Developer.domo.com questions and get answers from Domo peers
Add-ins & Plugins
Ask questions about plugins, Microsoft add-ins, and other third-party software integrations.
Domo Community Gallery
Watch how our Customers are using Domo to solve their complex problems.
Product Releases
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Domo University
Questions or discussions related to Domo University, trainings and certifications
Community Forums
Getting Started
Welcome to Domo's Community Forums! You'll find everything you need to get started in this category.
Community Announcements
Get the latest from Domo's Community Team.
Social Groups
Archive
Old or outdated content that could still be found helpful.