Feature #1712

add custom fields that are calculations of other fields

Added by Burt Culver almost 5 years ago. Updated about 1 month ago.

Status:NewStart date:2008-07-30
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Custom fields
Target version:-
Resolution:

Description

My company wants to score issues on a issue level rather than a project level. In order to do so we'd like a custom field that can be a calculation based on other issue fields. For example, we could have a custom field called score that would be a sum of priority * custom field priority_weight + time_estimate * custom field time_est_weight + custom field risk * custom field risk_weight + custom filed income_potential * custom field income_potential_weight, where weight would be some number between -10 and 10.

Adding custom fields that allowed calculation would give us the flexibility to do this. The field could be something like a formula field in a google doc spreadsheet. ie: my_custom_field = if(est_time > 3, 10, 5)*est_time_weight

That might be a lot to do, but it would be the ultimate in flexibility. All we need is simple addition/subtraction and multiplication. Although multiplying times "severity" field might be hard if it isn't an integer already.

Is it possible to sponsor work? If so, how much does it cost? (I ask without yet having the boss's approval mind you).

History

#1 Updated by chris madler over 3 years ago

+1
Support the motion. In my company something very similar is needed: a field priority, which is calculated from the issue's "business_value" and "development_effort" ie priority is highest when business value is greatest and development_effort is lowest, and vice-versa.

Chris

#2 Updated by Benedikt Naessens about 3 years ago

+1

We would find this possibility also very useful.

#3 Updated by Diego Felipe over 2 years ago

+1
I also would like a custom aggregate field to be exposed in custom aggregated queries.

#4 Updated by Matthias Neubert about 2 years ago

+1
We would need it to. I just wanted to create a new Issue for this, but I found this one here.
Could a developer of redmine please post some opinions or informations about this?
If we would know more about it and redmine internals we even would be able to contribute to redmine project.

#5 Updated by Andy Dufilie over 1 year ago

+1

#6 Updated by Terence Mill over 1 year ago

+1

#7 Updated by Adam Sneller over 1 year ago

+1

#8 Updated by Matthias Neubert over 1 year ago

+1 this issue is over 3 years old but it is interesting. Is it meant to be scheduled?

#9 Updated by Terence Mill 11 months ago

+1

#10 Updated by Janos Biro 10 months ago

+1

#11 Updated by Cristina Aurrecoechea 10 months ago

+1

#12 Updated by Sylvain Langlade 10 months ago

+1

#13 Updated by Artur M 10 months ago

+1

#14 Updated by Eric Diaz 8 months ago

+1

#15 Updated by Martin G 4 months ago

+1

Also available in: Atom PDF