Feature #6571

Totalise numeric columns

Added by James Robertson about 7 years ago. Updated almost 2 years ago.

Status:ClosedStart date:2010-10-05
Priority:NormalDue 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.19 KB) James Robertson, 2011-09-14 07:15


Related issues

Related to Redmine - Feature #1561: Totals for estimated/spent time and numeric custom fields... Closed 2008-07-02
Related to Redmine - Patch #2268: Patch to show Total Estimated Time at the bottom of each ... Closed 2008-12-03
Related to Redmine - Patch #4776: Totals for Estimated Time Closed 2010-02-09
Related to Redmine - Feature #8559: Sum columns in reports Closed 2011-06-07

History

#1 Updated by loic Le Gallou about 7 years ago

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

#2 Updated by Terence Mill about 7 years ago

+1

#3 Updated by Mischa The Evil about 7 years 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 about 7 years 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 almost 7 years 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 about 6 years 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 about 6 years 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 almost 6 years 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

#9 Updated by Zbynek Drlik over 4 years ago

+1

#10 Updated by Александр Александрук over 4 years ago

+1.

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.

It will be very usefull! Jean-Philippe Lang, Please add this feature in 2.4.0 :)

#11 Updated by Sebastian Paluch almost 3 years ago

+1

#12 Updated by Maxim Drozdov over 2 years ago

+1

#14 Updated by Sebastian Paluch almost 2 years ago

This one and bunch of related could be closed as the functionality was implemented by #1561.

#15 Updated by Toshi MARUYAMA almost 2 years ago

  • Status changed from New to Closed

Sebastian Paluch wrote:

This one and bunch of related could be closed as the functionality was implemented by #1561.

Thank you for your pointing out.

Also available in: Atom PDF