Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JIRA Structure Field: Resource traffic light in percent

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

 

1 answer

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]

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
Community showcase
Published in Jira

⏰ Day in the life of a Jira Admin!

Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...

162 views 2 14
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you