Feature #6571: Totalise numeric columns - Redmine

Custom queries

Documentation issues
Open defects
Open features
Patch queue
Plugin issues
Translation patches

Actions

Copy link

Feature #6571

closed

Totalise numeric columns

Added by James Robertson about 14 years ago. Updated almost 9 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Category:

Issues

Target version:

Start date:

2010-10-05

Due date:

% Done:

Estimated time:

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.

Files

redmine_totals.user.js (3.19 KB) redmine_totals.user.js

Greasemonkey/Scritish user script to totalise numeric columns in Redmine issue lists

James Robertson, 2011-09-14 07:15

Related issues

Related to Redmine - Feature #1561: Totals for estimated/spent time and numeric custom fields on the issue list

Closed

Jean-Philippe Lang

2008-07-02

Actions

Related to Redmine - Patch #2268: Patch to show Total Estimated Time at the bottom of each list of issues.

Closed

2008-12-03

Actions

Related to Redmine - Patch #4776: Totals for Estimated Time

Closed

2010-02-09

Actions

Related to Redmine - Feature #8559: Sum columns in reports

Closed

2011-06-07

Actions

Issue # Delay: days Cancel

History
Notes
Property changes

Actions

Copy link

Updated by loic Le Gallou about 14 years ago

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

Actions

Copy link

Updated by Terence Mill about 14 years ago

Actions

Copy link

Updated by Mischa The Evil about 14 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.

Actions

Copy link

Updated by James Robertson about 14 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?

Actions

Copy link

Updated by Mischa The Evil almost 14 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...

Actions

Copy link

Updated by James Robertson about 13 years ago

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.

Actions

Copy link

Updated by James Robertson about 13 years ago

File redmine_totals.user.js redmine_totals.user.js added

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 :-)

Actions

Copy link

Updated by Mischa The Evil about 13 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

Actions

Copy link

Updated by Zbynek Drlik over 11 years ago

Actions

Copy link

#10

Updated by Александр Александрук over 11 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 :)

Actions

Copy link

#11