Feature #1712

add custom fields that are calculations of other fields

Added by Burt Culver about 9 years ago. Updated almost 2 years 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).


Related issues

Related to Redmine - Feature #8177: Custom Field with mathematical calculation New 2011-04-18
Duplicated by Redmine - Feature #8599: Calculated Custom Field? Closed 2011-06-13
Duplicated by Redmine - Feature #17535: Custom fields maths Closed
Duplicated by Redmine - Feature #17582: advanced awesome calculated computed custom fields Closed

History

#1 Updated by chris madler almost 8 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 over 7 years ago

+1

We would find this possibility also very useful.

#3 Updated by Diego Felipe almost 7 years ago

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

#4 Updated by Matthias Neubert over 6 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 about 6 years ago

+1

#6 Updated by Terence Mill about 6 years ago

+1

#7 Updated by Adam Sneller almost 6 years ago

+1

#8 Updated by Matthias Neubert almost 6 years ago

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

#9 Updated by Terence Mill over 5 years ago

+1

#10 Updated by Janos Biro over 5 years ago

+1

#12 Updated by Sylvain Langlade over 5 years ago

+1

#13 Updated by Artur M about 5 years ago

+1

#14 Updated by Eric Diaz about 5 years ago

+1

#15 Updated by Martin G over 4 years ago

+1

#16 Updated by Adriano Ceccarelli over 4 years ago

+1

#18 Updated by Adnan Topçu almost 4 years ago

+1
Our guys wants to see issue age in the issue list.

#19 Updated by Damian G almost 4 years ago

+1

#20 Updated by Kevin Tinholt almost 4 years ago

+1

#21 Updated by Brruno Olímpio over 3 years ago

+1

Some news?

#23 Updated by Laurent Dairaine over 2 years ago

+1

#24 Updated by Marcelo Demestri over 2 years ago

+1

#25 Updated by Tristan P over 2 years ago

+ 999999999 :-)

#26 Updated by Jan Niggemann (redmine.org team member) over 2 years ago

#27 Updated by Sebastian Paluch over 2 years ago

+1

#28 Updated by Adnan Topçu over 2 years ago

+1

#29 Updated by Toshi MARUYAMA about 2 years ago

#30 Updated by Toshi MARUYAMA about 2 years ago

  • Duplicated by Feature #17582: advanced awesome calculated computed custom fields added

#31 Updated by Toshi MARUYAMA about 2 years ago

  • Related to Feature #8177: Custom Field with mathematical calculation added

#32 Updated by Brruno Olímpio about 2 years ago

+1

#33 Updated by Yakov Annikov about 2 years ago

I made a plugin with similar functionality. You can try it https://www.redmine.org/plugins/computed_custom_field

#34 Updated by Ingo Gellrich about 2 years ago

This sounds great.
Would there be the possibility to include standard fields (like estimated work, remaining work) from Redmine objects (trackers, users, projects) in the calculation? Or do you support custom fields only for now?

Regards
Ingo

Yakov Annikov wrote:

I made a plugin with similar functionality. You can try it https://www.redmine.org/plugins/computed_custom_field

#35 Updated by Sebastian Paluch about 2 years ago

Yakov Annikov wrote:

I made a plugin with similar functionality. You can try it https://www.redmine.org/plugins/computed_custom_field

I have tested it and I like it. It is simple and does work very well. The only nuisance is that computed custom field is editable when adding or editing issues. I thing the views\issues\_form_custom_field.html.rb should be adjusted to not render computed custom fields. As a workaround, the computed field can be set as read only using workflow permissions.

I would vote for adding this to Redmine core! This is very small change but it gives huge possibilities.

Can you convert it into patch and add tests? It would be easier to convince JPL to include it :)

#36 Updated by Yakov Annikov almost 2 years ago

Ingo Gellrich wrote:

This sounds great.
Would there be the possibility to include standard fields (like estimated work, remaining work) from Redmine objects (trackers, users, projects) in the calculation? Or do you support custom fields only for now?

Regards
Ingo

Yakov Annikov wrote:

I made a plugin with similar functionality. You can try it https://www.redmine.org/plugins/computed_custom_field

It is possiblle to use standart methods and fields of objects, for example a formula of Issue CF:

(self.estimated_hours || 0) * 2

#37 Updated by Yakov Annikov almost 2 years ago

Sebastian Paluch wrote:

Yakov Annikov wrote:

I made a plugin with similar functionality. You can try it https://www.redmine.org/plugins/computed_custom_field

I have tested it and I like it. It is simple and does work very well. The only nuisance is that computed custom field is editable when adding or editing issues. I thing the views\issues\_form_custom_field.html.rb should be adjusted to not render computed custom fields. As a workaround, the computed field can be set as read only using workflow permissions.

I would vote for adding this to Redmine core! This is very small change but it gives huge possibilities.

Can you convert it into patch and add tests? It would be easier to convince JPL to include it :)

Thank you for your note. The plugin is still in development. Maybe patch and test would be later.

Also available in: Atom PDF