Forum Discussion

pparke's avatar
pparke
Frequent Visitor
6 years ago

Identify missing employees from two tables

Hi All,

 

I have two tables. One with period no and a list of all active employees (employee id). I then have another table with period No and all empoyees who have submitted timesheets. I have created a variance chart by XVIZ and I want to show a table of all employees who have not submitted timesheets i.e the variance between the two. I was hoping when I clicked the variance component of the chart, this would identify what I am lookoing for but it just shows all employees who did submit timesheets in that period. 

 

Any ideas on other visuals I could use or how I can achieve this?

 

Thanks You!