Summary columns can be used to count totals, and to calculate maximum,Ā minimum, and average values withinĀ Tabular Reports.
Besides Summary columns there are a few other features in Targetprocess that support custom calculations. More information:Ā Custom Calculations and Formula Expressions
Hereās how you can create summary columns:
The first column will display the Ńount of Bugs for a User Story, the second - total effort for all the Tasks. In the third column you will see the date when time was first posted to this User Story (when the work has started). Fourth column shows which role has the max effort ToDo (if the User Story can be assigned to multiple roles). Fifth column - avg time spent on Requests.
The functions available (totals / avg /sum / min /max) depend on the property selected, e.g. you cannot count or sum up dates.
Some of the entities have no properties to list. You cannot add summary columns if Time is selected as the top-level entity.
You can also use filters in summary columns. Hereās how we can count only the āBlockingā Bugs:
The Severity name should be spelled exactly as in TargetProcess: Blocking.
Please donāt mix up the global āFiltersā tab in Custom Reports wizard with the filters for summary columns. The āFiltersā tab filters out top-level entities, and filters in Summary columns - the properties of your listed entities.
Thatās how the final summary report looks in our case. Only Bugs with the āBlockingā severity are included:
Another example of Summary Columns inside a Custom Report can help you to getĀ filtered and aggregated totals for Times and Efforts per User Story, Feature, Iteration, Release, Team Iteration or even Project or Team.
Still have a question?
We're here to help! Just contact our friendly support team
Or contact
a sales representative
Get a live
product demo
Let one of our product specialists create your account
and shape Targetprocess for your
company needs.