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 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
Updated by Benedikt Naessens over 14 years ago
+1
We would find this possibility also very useful.
Updated by Diego Felipe about 14 years ago
+1
I also would like a custom aggregate field to be exposed in custom aggregated queries.
Updated by Matthias Neubert almost 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 13 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 about 11 years ago
+1
Our guys wants to see issue age in the issue list.
Updated by Jan Niggemann (redmine.org team member) over 9 years ago
- Has duplicate Feature #8599: Calculated Custom Field? added
Updated by Toshi MARUYAMA over 9 years ago
- Has duplicate Feature #17535: Custom fields maths added
Updated by Toshi MARUYAMA over 9 years ago
- Has duplicate Feature #17582: advanced awesome calculated computed custom fields added
Updated by Toshi MARUYAMA over 9 years ago
- Related to Feature #8177: Custom Field with mathematical calculation added
Updated by Yakov Annikov over 9 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 over 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
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 :)
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
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 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.
Updated by ashraf alzyoud over 5 years ago
- File Untitled.png Untitled.png added
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.
Updated by Holger Just over 2 years ago
- Related to Feature #36992: redmine computed custom field added
Updated by Holger Just 9 months ago
- Has duplicate Feature #13334: Custom Fields mod. before commit to db added