I'm not really following what you're saying. Can you step back from the data and just explain what it is you're trying to do? What is your goal?
So each day our researchers should be logging the hours they work on each subject. Right now it is not "required" for them to enter hours each day according to the system but management does require them to do so. The hours for our purposes are important for timing our products and deliverables so we are able to accurately price and allocate our work.
When a user does enter hours there will be a date field associated with it. If they do not enter hours there is no new row of data for that date. So currently if Jane Doe enters hours for 1/1, 1/2, and 1/4, I am unable to to say "show me the dates (1/3) Jane did not enter hours for" because there is no row of data for Jane that corresponds to 1/3.
I hope that makes sense!
2 of 2 people found this helpful
Understood. You'll need to build a data scaffold that ensures that each employee has a record for each date. I just answered a very similar question the other day, so take a look at my answer here: Count Employee missing Date Entries
Thanks, Ken! Exactly what I needed