WorkRatio field in Jira Plans

[Puneet Gupta]

Hello Experts,

I am using JQL for one of my project and able to reference the field WorkRatio.

But this field is not appearing in the Jira Plans, how can I add this field under the Jira Plans.

Any help would be appreciated!!

Thanks 

[pawarsachin84 · Accepted solution]

Hello @Puneet Gupta ,

Thank you for your question.

You're correct that the Work Ratio field (which shows the ratio of Actual Time Spent vs Estimated Time) is available in Jira's issue view. However, Jira Plans supports limited set of fields.

You can give a try to implement and create a custom number field (e.g., Custom Work Ratio) and use Jira Automation to calculate: (something like below)

{{issue.timetracking.timeSpent}} / {{issue.timetracking.originalEstimate}}

Then display this field in your Plan.

For more details about adding fields to plan please refer below.

Add and view custom fields in your plan

Enable custom fields to use in your plan

[Ashok Shembde]

Use Jira Automation:

1. Create a custom number field Work Ratio %.

2. Create a scheduled rule (or trigger on issue update):

   • Condition: Original Estimate & Time Spent are not empty.

   • Action: Edit Work Ratio % field using smart values:

     jinja

     {{#=}}{{issue.timetracking.timeSpentSeconds}} / {{issue.timetracking.originalEstimateSeconds}} * 100{{/}}

3. Once populated, this field can be used in Jira Plans