Visualizing Tasks Done per Work Hour
I am having a hard time creating a dataset to allow me to visualize tasks done per work hour by an employee. The problem is I have two datasets to start with (tasks and daily schedule) which only have a single commonality being date.
The tasks dataset creates a new row for each task done in our system which could potentially be 100+ tasks a day per person. The schedule dataset lists each employee each day on a row with their start time/end time and total hours worked.
What would you suggest for bringing these two together to visualize?