Feature #8559

Sum columns in reports

Added by Bevan Rudge over 3 years ago. Updated almost 3 years ago.

Status:NewStart date:2011-06-07
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Issues
Target version:-
Resolution:

Description

It would be nice if Redmine could operate on all the values in a group/column of an issues report in order to, for example;
  • Show the total estimated time
  • Show the total/average progress/level of effort/priority

It would be nice if this was done for groups (if the report is grouped by) and for all the groups (or the total if there is no grouping for the report).

The attached screenshot shows an example of this. It was created using the attached javascript in a JS console like Firebug.

Estimate_total.jpeg (36.4 KB) Bevan Rudge, 2011-06-07 23:37

total-estimate.js (1.17 KB) Bevan Rudge, 2011-06-07 23:37


Related issues

Related to Feature #1561: Please provide totals for the estimated time column New 2008-07-02
Related to Patch #2268: Patch to show Total Estimated Time at the bottom of each ... New 2008-12-03
Related to Patch #4776: Totals for Estimated Time New 2010-02-09
Related to Feature #6571: Totalise numeric columns New 2010-10-05

History

#1 Updated by Ruedi Silvestri about 3 years ago

+1 it would even be very valueable if such calculation could also be enabled for custom fields.

#2 Updated by Terence Mill about 3 years ago

+1

#3 Updated by fake plastic tree almost 3 years ago

+1 this would make reporting much more powerfull.

#4 Updated by Tony Marschall almost 3 years ago

There is a plugin providing this feature: https://github.com/planio/redmine_spent_time_column

#5 Updated by Mischa The Evil almost 3 years ago

Tony Marschall wrote:

There is a plugin providing this feature: https://github.com/planio/redmine_spent_time_column

Thanks for pointing this out, Tony. It looks like a useful plugin which will fullfill a lot of requirements looking at the issues at redmine.org (see below). I've did a quick compatibility-test on source:/trunk@7623 and everything seems to work as expected (what I already expected to be honest :).

Regarding this issue: it is actually a duplicate of already multiple issues filed here at redmine.org. I know some out of my mind (euh, without looking it up). For now I'll just add these as issue-relations. I'll see if I can find more "relatives" and if they can be combined into one (or more) generic issues in time... Here we go:

Btw: A quick comparison of the available patches in all these issues against the solution implemented in the above mentioned plugin gives me the "feeling" that the best way to implement such a feature in a (current) stock Redmine is to use this plugin instead of patching the Redmine core yourself.

#6 Updated by Lionel VEILLEPEAU almost 3 years ago

It will be better in the trunk, the redmine_spent_time_column plugin doesn't work with the redmine_xls_export plugin.

Also available in: Atom PDF