[Solved] How to work out average of tasks started early

Hi, I am building a time blocking app, and record both when a task is due to start and when it is actually started.

How do I return the average time that a user starts their tasks early or late?

I am thinking something like:
add up all the due to start times and
subtract them from the actual start times,
divided by the number of tasks started

However, I can’t seem to get it to do that… There must be a better way!

Hi there, @StandUp… if I was doing what you described, I probably wouldn’t want to try to figure that stuff out on the fly. That being said, I might add fields to the Task data type to store if a task was started early or late (maybe using an option set to provide the early and late options) and the number of minutes before or after the task’s due date/time when the task was actually started. With those fields in place, it would be easy to figure out how often a user starts their tasks early or late as well as the average number of minutes early or late that the tasks are started.

Anyway, just some food for thought there, and I hope it helps.

Best…
Mike

1 Like

Good call, I’ll do that, thanks!

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.