title: Tableau---Getting count from 2 different data sources and combining into one total
body: <p>I am a tableau newbie and am trying to see if this is possible or not.  I have 2 separate data sources where the same employees are listed, one is for closed cases and the other is for open cases.  These data sources have some of the same columns, but for the most part they are different.</p>
  
  <p>Is it possible to aggregate the case count for each employee on the closed and open data sources into a single column? For instance, if an employee has 50 closed cases and 23 open cases, I want it to show 73 for them.</p>
  
  <p>I attempted to play around with the joins/unions but these didn't work properly and duplicated the data most times.</p>