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.