Feature #1712
openadd custom fields that are calculations of other fields
0%
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
Related issues
       Updated by chris madler about 16 years ago
      Updated by chris madler about 16 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
       Updated by Benedikt Naessens over 15 years ago
      Updated by Benedikt Naessens over 15 years ago
      
    
    +1
We would find this possibility also very useful.
       Updated by Diego Felipe about 15 years ago
      Updated by Diego Felipe about 15 years ago
      
    
    +1
I also would like a custom aggregate field to be exposed in custom aggregated queries.
       Updated by Matthias Neubert over 14 years ago
      Updated by Matthias Neubert over 14 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.
       Updated by Matthias Neubert almost 14 years ago
      Updated by Matthias Neubert almost 14 years ago
      
    
    +1 this issue is over 3 years old but it is interesting. Is it meant to be scheduled?
       Updated by Adnan Topçu almost 12 years ago
      Updated by Adnan Topçu almost 12 years ago
      
    
    +1
Our guys wants to see issue age in the issue list.
       Updated by Jan Niggemann (redmine.org team member) over 10 years ago
      Updated by Jan Niggemann (redmine.org team member) over 10 years ago
      
    
    - Has duplicate Feature #8599: Calculated Custom Field? added
       Updated by Toshi MARUYAMA over 10 years ago
      Updated by Toshi MARUYAMA over 10 years ago
      
    
    - Has duplicate Feature #17535: Custom fields maths added
       Updated by Toshi MARUYAMA over 10 years ago
      Updated by Toshi MARUYAMA over 10 years ago
      
    
    - Has duplicate Feature #17582: advanced awesome calculated computed custom fields added
       Updated by Toshi MARUYAMA over 10 years ago
      Updated by Toshi MARUYAMA over 10 years ago
      
    
    - Related to Feature #8177: Custom Field with mathematical calculation added
       Updated by Yakov Annikov about 10 years ago
      Updated by Yakov Annikov about 10 years ago
      
    
    I made a plugin with similar functionality. You can try it https://www.redmine.org/plugins/computed_custom_field
       Updated by Ingo Gellrich about 10 years ago
      Updated by Ingo Gellrich about 10 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
       Updated by Sebastian Paluch about 10 years ago
      Updated by Sebastian Paluch about 10 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 :)
       Updated by Yakov Annikov almost 10 years ago
      Updated by Yakov Annikov almost 10 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
IngoYakov 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
       Updated by Yakov Annikov almost 10 years ago
      Updated by Yakov Annikov almost 10 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.
       Updated by ashraf alzyoud over 6 years ago
      Updated by ashraf alzyoud over 6 years ago
      
    
    - File Untitled.png Untitled.png added
       Updated by Andrzej Karwowski about 5 years ago
      Updated by Andrzej Karwowski about 5 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.
       Updated by Holger Just over 3 years ago
      Updated by Holger Just over 3 years ago
      
    
    - Related to Feature #36992: redmine computed custom field added
       Updated by Holger Just over 1 year ago
      Updated by Holger Just over 1 year ago
      
    
    - Has duplicate Feature #13334: Custom Fields mod. before commit to db added
 Updated by Anonymous
      Updated by Anonymous