JIRA Structure Field: Resource traffic light in percent

Jurica Petricevic

Hi Community,

for the purpose of better presentation we have one problem.

Resources traffic light is a Fieldname that we need in Structure.

 

the logic behind this is this:

This is the formula:

Resource traffic light in percent = (total time bookings + total remaining effort) / original estimate

 

and the results should be presented as follows

0 bis inkl. 110% - Green

111 bis inkl. 120% - Yellow

bigger then 120% - Red

 

Any tips or help here?

 

Best regards

Jurica

 

Dionathan Lopes {ALM Works}

Hello Jurica,

Thank you for sharing your Structure Formulas question here on the Atlassian Community

Here is an example formula you could use as a template

with traffic = IF (DEFINED(original_estimate); (total_time_bookings + total_remaining_effort)/ original_estimate):
IF(
traffic <= 110;
"{color:Green}Green{color}";
traffic > 110 and traffic <= 120;
"{color:Yellow}Yellow{color}";
traffic > 120;
"{color:Red}Red{color}"
)

Here are the things you will want to update to accommodate your use case:

• You will need to change the variables' names ("original_estimate", "total_time_bookings", "total_remaining_effort") for the related field names that you have on your instance.
• You would also need to change the Format to "Wiki markup", by selecting it on the dropdown list right next to the "Options" field. Please refer to this article for more information - https://wiki.almworks.com/display/structure/Formulas

Please let me know if it helps.

Best Regards,
Dionathan Lopes
[ALM Works]