Using two distinct data sets in one card
I have two datasets.
The first has the dealers name with how many accounts they have.
For example:
Company name | Total # Accounts |
Company A | 1990 |
Company B | 450 |
Company C | 3000 |
The second shows all of the alarms for a given period and which account and dealer they are for.
For example:
Alarm Date | Account # | Company Name |
1/15/2016 | H12345 | Company A |
2/16/2016 | J4321 | Company A |
1/2/2016 | K98444 | Company B |
1/25/2016 | LO48354 | Company C |
1/12/2016 | HJ32454 | Company A |
I want the card to be able to show me the total number of alarms that each company had in a stacked or group bar graph and then compare that to their total number of accounts.
I can make each card seperate, but I can't figure out how to combine them both so that it looks like the attached image where the green column shows total number of accounts and the red column shows total number of alarms. This way I can see the percent of accounts had alarms for each dealer.
Any thoughts?
0
Comments
-
You will want to combine the two data sets into one data set. If I interpret your tables correctly, your first table is already a summary table by company. The second is a detail table that you want to summarize. Using ETL, bring the detail table in as a source, and use the Group by function to create a summary table. When you drag the Group by box into the ETL screen you will be asked to select the column that identifies the grouping - in the example this is the Company Name field. You then select name of the new field: I use "Total Alarms". Choose a field to aggregate: "Account #" and the the aggregation type: "Count". Bring in the second data set using the Input Data set widget. It will ask you to select the columns to join on: which is "Company Name" in both tables from your example. You can also select the type of join (left, right, inner, full) to get the right data set. Link this to an output data set and you then can use that set to do the card in question . Ultimately your ETLO will look something like the attached. Let me know if you have more questions or would like details.Dojo Community Member
** Please like responses by clicking on the thumbs up
** Please Accept / check the answer that solved your problem / answered your question.1
This discussion has been closed.
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 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