I'm trying to understand exactly how the "Duration (Average)" value is being calculated in a Task report.

The report is grouped by Status and displays an aggregated Duration (Average) value.

Example:

Status: Complete (4)

• Discovery – Duration: 4 Days

• Discovery Tasks – Duration: 0 Days

• Marketing Snapshot – Duration: 0 Days

• Discovery Approved – Duration: 3 Days

Report displays:

• Duration (Average): 1.5 Days

Status: New (27)

• Requirements Planning – Duration: 4 Days

• Requirements Planning Tasks – Duration: 0 Days

• Marketing Plan – Duration: 0 Days

• RACI – Duration: 0 Days

• Additional tasks with mostly 0-day durations

Report displays:

• Duration (Average): 0.33 Days

My understanding is that the report may simply be averaging the native Task Duration field for all tasks in each status group.

Can someone confirm:

1. Is the "Duration (Average)" value calculated from the native Task Duration field?

2. Or is Workfront calculating the actual time a task spent in that status using status history/audit data?

3. If it is using the Task Duration field, how does Workfront calculate the average when grouped by Status?

4. Is there a native way to report on the actual time spent in each status (New, In Progress, Complete, etc.)?

Any documentation or explanation of the underlying calculation would be appreciated.