I am busy cleaning timesheet data and would like to remove those people that do not fill theirs in accurately and submit the same amount of hours each day (person A in table below). Is there a way I can add in a rule to this effect? i.e. For each individual with the same name, if hours variable is constant remove these observations - data for person A would be deleted and data for person B retained
Person | Hours worked per day |
A | 12 |
A | 12 |
A | 12 |
B | 9 |
B | 15 |
B | 13 |
Thank you!
Solved! Go to Solution.
Hi @CD11
If you perform countdistinct of the values grouped by person, you'll then be able to filter out those below some threshold
Note that I added a person C to your input data to have a bit more variety.
Dan
Thank you - works perfectly!