Project

General

Profile

Actions

Feature #1712

open

add custom fields that are calculations of other fields

Added by Burt Culver over 16 years ago. Updated about 1 year ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Custom fields
Target version:
-
Start date:
2008-07-30
Due date:
% Done:

0%

Estimated time:
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).


Files

Untitled.png (21.5 KB) Untitled.png ashraf alzyoud, 2019-05-03 23:19

Related issues

Related to Redmine - Feature #8177: Custom Field with mathematical calculationNew2011-04-18

Actions
Related to Redmine - Feature #36992: redmine computed custom fieldClosed

Actions
Has duplicate Redmine - Feature #8599: Calculated Custom Field?Closed2011-06-13

Actions
Has duplicate Redmine - Feature #17535: Custom fields mathsClosed

Actions
Has duplicate Redmine - Feature #17582: advanced awesome calculated computed custom fieldsClosed

Actions
Has duplicate Redmine - Feature #13334: Custom Fields mod. before commit to dbClosed

Actions
Actions #1

Updated by chris madler about 15 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

Actions #2

Updated by Benedikt Naessens over 14 years ago

+1

We would find this possibility also very useful.

Actions #3

Updated by Diego Felipe about 14 years ago

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

Actions #4

Updated by Matthias Neubert over 13 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.

Actions #5

Updated by Anonymous about 13 years ago

+1

Actions #6

Updated by Terence Mill about 13 years ago

+1

Actions #7

Updated by Adam Sneller almost 13 years ago

+1

Actions #8

Updated by Matthias Neubert almost 13 years ago

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

Actions #9

Updated by Terence Mill over 12 years ago

+1

Actions #10

Updated by Janos Biro over 12 years ago

+1

Actions #12

Updated by Sylvain Langlade over 12 years ago

+1

Actions #13

Updated by Artur M over 12 years ago

+1

Actions #14

Updated by Eric Diaz about 12 years ago

+1

Actions #15

Updated by Martin G almost 12 years ago

+1

Actions #16

Updated by Adriano Ceccarelli over 11 years ago

+1

Actions #18

Updated by Adnan Topçu almost 11 years ago

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

Actions #19

Updated by Anonymous almost 11 years ago

+1

Actions #20

Updated by Kevin Tinholt almost 11 years ago

+1

Actions #21

Updated by Brruno Olímpio almost 11 years ago

+1

Some news?

Actions #23

Updated by Laurent Dairaine over 9 years ago

+1

Actions #24

Updated by Marcelo Demestri over 9 years ago

+1

Actions #25

Updated by Tristan P over 9 years ago

+ 999999999 :-)

Actions #26

Updated by Jan Niggemann (redmine.org team member) over 9 years ago

Actions #27

Updated by Sebastian Paluch over 9 years ago

+1

Actions #28

Updated by Adnan Topçu over 9 years ago

+1

Actions #29

Updated by Toshi MARUYAMA over 9 years ago

Actions #30

Updated by Toshi MARUYAMA over 9 years ago

  • Has duplicate Feature #17582: advanced awesome calculated computed custom fields added
Actions #31

Updated by Toshi MARUYAMA over 9 years ago

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

Updated by Brruno Olímpio about 9 years ago

+1

Actions #33

Updated by Yakov Annikov about 9 years ago

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

Actions #34

Updated by Ingo Gellrich about 9 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

Actions #35

Updated by Sebastian Paluch about 9 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 :)

Actions #36

Updated by Yakov Annikov about 9 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

Actions #37

Updated by Yakov Annikov about 9 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.

Actions #38

Updated by ashraf alzyoud over 5 years ago

thx alot yakov aanikov

can u see the pic attachment
i need use this in 3 way
#1 project , #2 sub project , # 3 issue (a) , 4# issue (b)
  • in issue #3 we have traker GOAL and we create 3 task tracker TASK
  • in issue #4 we have traker result
    1- collect custom field from subtask to task leverl
    2- collect custom field from task to tracker level
    3 collect custom field from all issiue to issiue
Actions #39

Updated by Florian ROBERT over 5 years ago

+1

Actions #40

Updated by Matteo Turra almost 5 years ago

+1

Actions #41

Updated by Jihyeon Gim over 4 years ago

+1

Actions #42

Updated by Andrzej Karwowski about 4 years ago

yakov aanikov: https://www.redmine.org/plugins/computed_custom_field - This project is no longer maintained - compatible with Redmine 4.0.x, and what about Redmine 4.1?

This feature is very needed.

Actions #43

Updated by Bertrand Michas almost 4 years ago

+1

Actions #44

Updated by Alexey Tveritinov almost 4 years ago

+1

Actions #45

Updated by Alexandr Chernyaev over 3 years ago

+1

Actions #47

Updated by Alexandr Chernyaev over 2 years ago

+1

Actions #48

Updated by Holger Just over 2 years ago

Actions #49

Updated by Kamil AFACAN over 1 year ago

Still needed
+1

Actions #50

Updated by Jenny Malig about 1 year ago

Highly required
+1

Actions #51

Updated by Holger Just 8 months ago

  • Has duplicate Feature #13334: Custom Fields mod. before commit to db added
Actions

Also available in: Atom PDF