Allow aggregation of duration columns in groupings and whole view | Voters

Allow aggregation of duration columns in groupings and whole view

Nathan Arant

When using duration fields, it would be very helpful to be able to sum/have average values for those columns for groupings, like other numeric fields. At the moment, I have to manually calculate the sum of hours and minutes which is time-consuming and archaic.

January 8, 2024

Autopilot

Merged in a post:

Duration Field is numerical, but doesn't have a quantity sum in grid view: Add numerical summary option

Savannah Harris

In grid view, fields with numerical data usually support a numerical summary type. Unfortunately, that's not the case with the duration field. Despite the numerical values being in minutes/hours, you cannot click to view a summary of the data as you can with other fields.

The ability to see a summary of time would be helpful for job flows and data reporting at a glance. Understanding at a glance how many billable hours were spent is vital. Being able to see summary values for percent filled/percent empty is not as helpful as being able to see the total minutes/hours spent across a collection of jobs. Please add the ability to numerically sum the duration field type in grid view.

February 3, 2026

Brian Dollen

Merged in a post:

Sum Allocated Time

Andrew Leger

The ability to "sum" up the allocated time record type would be helpful for our agency when computing total amount of time assigned to resources. I.e. Rach has 5 hours of allocated time assigned to her on Tuesday (summed up from 4 different tasks assigned to her.)

Currently the only options available to us are "None, Empty, Filled, Percent Empty, Percent Filled"

July 5, 2024