I'd like to create a workload tracking tool for a job that has predictable tasks, but is unpredictable regarding the timing of task entry into the workload queue.
Tasks arrive at unpredictable times/dates, and have a set number of days between arrival and due date for completion. I would like to be able to aggregate and trend a few count values across multiple time periods (weeks, months, quarters - either selectable or on separate reports) showing count of tasks arrived during the time period, count of tasks completed during the time period, count of uncompleted tasks in the workload queue at the end of the time period, and count of uncompleted and overdue tasks in the workload queue at the end of the time period. I expect to do manual data entry, of a task descriptor/identifier, arrival date, and completion date for each task, with hopefully all other needed information being automatically generated.
My initial thought was to do this with a pivot table, but despite the fact that I am fairly adept at pivot tables, I couldn't figure out how to manage to get this one to work.
Any help or guidance is appreciated.
Tasks arrive at unpredictable times/dates, and have a set number of days between arrival and due date for completion. I would like to be able to aggregate and trend a few count values across multiple time periods (weeks, months, quarters - either selectable or on separate reports) showing count of tasks arrived during the time period, count of tasks completed during the time period, count of uncompleted tasks in the workload queue at the end of the time period, and count of uncompleted and overdue tasks in the workload queue at the end of the time period. I expect to do manual data entry, of a task descriptor/identifier, arrival date, and completion date for each task, with hopefully all other needed information being automatically generated.
My initial thought was to do this with a pivot table, but despite the fact that I am fairly adept at pivot tables, I couldn't figure out how to manage to get this one to work.
Any help or guidance is appreciated.