how to create a report View average completion times for different types of tasks | Community
Skip to main content
Level 2
November 14, 2024
Solved

how to create a report View average completion times for different types of tasks

  • November 14, 2024
  • 1 reply
  • 850 views

hello everyone,

 I need to  create a kind of report where i can view the average completion times of different types of task  and how to show or highlight those with excessive times.

 

Thanks a lot

Hugo

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Madalyn_Destafney

Hi there,

If you have a task report capturing the tasks you're looking for in your filters, you can have a column for task > actual duration. Click on that duration column, then Advanced Options in the upper right, and you can select Average.

Then in your grouping, you can group by project type or task type if you have custom fields delineating this (or if not, can group by project template if you're template names give an indication of type). Collapse the grouping. Then you can save and see the avg durations in the groupings of by type (whatever type means for you).

Note this is pulling actual duration, so if users are not good at marking tasks complete you may want to use planned duration. You could add some conditional formatting to the duration column if you wanted so show any avg duration exceeding X days shows as red, for example.

1 reply

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity AdvisorAccepted solution
Community Advisor
November 18, 2024

Hi there,

If you have a task report capturing the tasks you're looking for in your filters, you can have a column for task > actual duration. Click on that duration column, then Advanced Options in the upper right, and you can select Average.

Then in your grouping, you can group by project type or task type if you have custom fields delineating this (or if not, can group by project template if you're template names give an indication of type). Collapse the grouping. Then you can save and see the avg durations in the groupings of by type (whatever type means for you).

Note this is pulling actual duration, so if users are not good at marking tasks complete you may want to use planned duration. You could add some conditional formatting to the duration column if you wanted so show any avg duration exceeding X days shows as red, for example.

If this helped you, please mark correct to help others : )
HugoZaAuthor
Level 2
November 19, 2024

thank you so much. I was applying different filters,  I re built my report and was successful. just in case we could help others 

Madalyn_Destafney
Community Advisor
Community Advisor
November 20, 2024

That’s great!

If this helped you, please mark correct to help others : )