Hey team,
I’m trying to accurately track how many concurrent tasks are running ahead of the time estimate, on time with the estimate, or behind the time estimate needed for its completion.
Currently, my team will receive a job and will put in an estimation of a time needed to complete the task. The task is then scheduled for a later date. Once the task has been completed, we have an additional column for the team member to put how long the task actually took them.
The issue I’m encountering is looking on my KPI dashboard is this: All tasks that have Time Estimate (a number column) filled in with data, but don’t have Actual Time (also a number column) filled in, due to the work not being completed yet, are showing as behind time estimate and is a false indicator of the current work.
How best can I filter this data to discount tasks that don’t yet have an actual time number filled in?