Feature #6571

Totalise numeric columns

Added by James Robertson over 1 year ago. Updated 7 months ago.

Status:New Start date:2010-10-05
Priority:Normal Due date:
Assignee:- % Done:

0%

Category:Issues
Target version:-
Resolution:

Description

In the issue/ticket query/filter view, it would be help to see totals for (some) numeric columns.

For example we often need a total of the Estimated time column.

One simple option would be to show a total, at the bottom of the page, for any numeric field/column. Alternatively, it could be a configuration option to show a total only for specified numeric fields.

redmine_totals.user.js - Greasemonkey/Scritish user script to totalise numeric columns in Redmine issue lists (3.2 kB) Magnifier James Robertson, 2011-09-14 07:15


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 ... Assigned 2008-12-03
related to Patch #4776: Totals for Estimated Time New 2010-02-09
related to Feature #8559: Sum columns in reports New 2011-06-07

History

#1 Updated by loic Le Gallou over 1 year ago

+1. Remaining time computation based on Estimated time and progress would be also very usefull.

#2 Updated by Terence Mill over 1 year ago

+1

#3 Updated by Mischa The Evil over 1 year ago

James Robertson wrote:

[...] For example we often need a total of the Estimated time column.

This has been requested before in #1561 and has been patched-in in #2268 and the following issue #4776.

#4 Updated by James Robertson over 1 year ago

  • Assignee set to Mischa The Evil

Thanks Mischa The Evil. Patch #4776 looks good, we'll probably install that.

I still feel that this is a universally useful feature though, and should be included in the trunk. What's the protocol here - do I just leave this ticket open?

#5 Updated by Mischa The Evil over 1 year ago

  • Assignee deleted (Mischa The Evil)

James Robertson wrote:

[...] I still feel that this is a universally useful feature though, and should be included in the trunk. What's the protocol here - do I just leave this ticket open?

Yes indeed, just leave it open and/or try to interest some more ppl for integration of this issue... :)

Note: I'm not actually working on this issue [sic] I have removed myself as the assignee...

#6 Updated by James Robertson 9 months ago

+1

I'd still like to (have the option to) display a total for any/every numeric field - not just estimated hours. Ideally the total of the the column should be display and the total for all issues, if more than one page of results.

#7 Updated by James Robertson 8 months ago

I have hacked together a Greasemonkey/Scriptish user script for adding totals to any numeric column in the issue list, browser-side. I've provided the script here in case it's of any use to anyone else.

Warning, I've only tested this in Chiliproject (Redmine fork). It's pretty fragile and relies on the table structure and class names remaining constant. I hope someone finds it useful and /or wants to make it better :-)

#8 Updated by Mischa The Evil 7 months ago

As mentioned the first time by Tony Marschall in #8559 note-4, there exists a plugin which provides (parts of) this feature (along with some others): Redmine spent time column. It's written by Jan Schulz-Hofen of plan.io.

I've started working on some improvements to make it better suitable for this issue in my fork of it:
https://github.com/MischaTheEvil/redmine_spent_time_column

Also available in: Atom PDF