Compute Percentage of Work and Define the current Status

Ray Balmeo Cagayon April 15, 2024

I have created the fields for my Automation project.

  • Remaining Test Hours
  • Shipping Time
  • Tool Status

Remaining Test Hours: {{issue.subtasks."Test Hours".sum}} - computes the remaing test hours from all the subtasks assigned to the issue.

Shipping Time:   {{"Need By Date".diff(now).hours.abs}} - calculates the time remaining hours left before shipment.

For the Tool Status: I have 3 predetermined values:

  1.  On Track - Remaining Test Hours < Shipping Time by a wide margin
  2. At Risk  -  Remaining Test Hours < Shipping Time by 25% 
  3. Delayed -  Remaining Test Hours > Shipping Time 

I just need a guide where to start and what is the best options i can do.






1 answer

1 accepted

1 vote
Answer accepted
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 15, 2024

Hello @Ray Balmeo Cagayon 

You can do this with an Automation Rule.

How do you want to trigger the rule?

  1. Do you want to run it periodically, on a schedule, and have it check a set of issues? If so, how would you determine what issue to check?
  2. Do you want it to recheck individual issue based on some action/event that has happened with the individual issue? If so, what would that event be?

To actually set the Tool Status field you could use an IF-ELSE construct.

Where I have the Edit Issue Fields action, that is where you would set the value of the Tool Status field.

Screenshot 2024-04-15 at 4.20.58 PM.pngScreenshot 2024-04-15 at 4.21.30 PM.png

Ray Balmeo Cagayon April 15, 2024

@Trudy Claspill

Let me give it a try.


Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events