Forum Discussion
Employee Absence Rate
Hi, I'm trying to calculate employee sickness absence rate, the end goal is to have a graph showing the absence rate for each month which will change when a different business area is selected. T...
A couple of things I noticed:
- You have a bi-directional crossfilter between Employee Info and Working Days. I'm assuming that Working Days is a look up table. I would change that to one direction.
- Everything except Sector has a Many to Many relationship, which means the value you are joining on both sides have duplicates. I assume you are joing Working Days on both tables. Why are there duplicates values on the Working Days table?
- Have you tried joining Employee Info to Sickness and Absence using Emp ID?
I'm afraid I'm unable to share the file due to the sensitivity of the data.
1. Would that be one directional from Employee Info to Working days?
2. What would I change it to?
3. What type of relationship would this be? Would this then filter all of the other matching columns?