Compute Percentage of Work and Define the current Status

[Ray Balmeo Cagayon]

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.

[Trudy Claspill · Accepted solution]

Hello @Ray Balmeo Cagayon 

You can do this with an Automation Rule.

https://support.atlassian.com/cloud-automation/docs/jira-cloud-automation/

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.

https://support.atlassian.com/cloud-automation/docs/jira-automation-conditions/#If-else-block

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

[Ray Balmeo Cagayon]

@Trudy Claspill

Let me give it a try.