Combining two data sets
Hi. I have two datasets. One is leads generated by date by employee (in addition to other fields). The other is hours worked by date by employee (in addition to other fields). I have tried to combine this with Magic ETL but the data never comes out right. I want to be able to calculate leads per hour and be able to display hours and leads on the same chart. I've matched on date and employee. I'm wondering if ETL is maybe not the right approach because each lead is one row whereas each day is a row in the hours dataset. Not sure. Help please.
Best Answer
-
Ahh... it might be best to try and re-ask the question on the BeastMode / ETL / DataFlow board - https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/bd-p/Beast - they'll know better the ins and outs of combining data.
I'm sorry I can't be of more help. I focus more in the individually connectors, how they work, etc.
0
Answers
-
@CBlandon - You might be able to find more help in the ETL / Dataflow area - https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/bd-p/Beast - but I'll take a stab at helping (I'm more connector savvy).
It would help to know what your end goal of this data is. Also, when you DO combine it what are you seeing and what do you want to be seeing?
0 -
The end goal is to be able to calculate leads by hour by employee. Leads and employee are in one data set. Hours and employee are in the other data set. What I'm seeing in the final data set is either no data at all in the fields (hours, leads, employee and I created a beastmode for leads per hour) or I only see data from the Hours data set.
0 -
Ahh... it might be best to try and re-ask the question on the BeastMode / ETL / DataFlow board - https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/bd-p/Beast - they'll know better the ins and outs of combining data.
I'm sorry I can't be of more help. I focus more in the individually connectors, how they work, etc.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive