Average of Time Worked by number of Tasks

[Russ Heard3]

Hi,

Trying to satisfy a user requirement. They want to find the average number of hours logged as Time Worked on Catalog Tasks, but the answer must be (total number of Time Worked hours) / (number of tasks). 

The various reports I've tried (based on the Time Worked table) are performing the average as (total number of Time Worked hours) / (number of Time Worked entries)  

The example they gave me:

Task 1 has 3 Time Worked entries - 3 days | 2 days 10 hours | 1 day 2 hours. Total = 6 days 12 hours.
Task 2 has 1 Time Worked entry -  1 day 12 hours. Total = 1 day 12 hours.

So the total Time Worked is 8 days, divided by 2 Tasks. They expect the report to give them the Average answer as 4 days.

However, the report is giving the answer as 2 days  (8 days divided by 4 entries).

Anyone done this before? Do I have to create a metric or other column calculating the total Time Worked per Task?    

Thanks

[Slawek_Radziewi]

I would suggest using Performance Analytics.

You need to create two indicators:

1. Total time of worked times (time worked table)

2. Total number of tasks (task table or time worked table distinct count on task field)

Create formula indicator (total number of Time Worked hours) / (number of tasks)  

[Kayla Kindred]

I do not have the Performance Analytics plugin to be able to do the above solution. Is there another option for me to be able to achieve this report? 

[Prerana1]

Hello ,

Did you find the solution for this?

Thanks