Comments
-
Thanks for the fast reply! I've tried left, right, and outer joins. None get me to where I want to be. How would I force a zero?
-
I'm running into this same problem. I have joined two datasets. One has leads per day by employee. The other has hours per day by employee. If an employee worked a particular but didn't generate any leads their hours for that day aren't showing up. This impacts a beastmode I created to calculate leads per hour. It's…
-
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…
