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

Calculate productivity and efficiency using JIRA automation

Hello Everyone,

I have an original estimate on a story and time spent data, which has been logged over Story Sub-Task and on story also. Manually, it's been getting difficult to calculate the productivity of my team and how efficient they are on a story level. So, is there a way using JIRA Automation that can help me to calculate productivity and efficiency from original estimation and time spent data?

1 answer

0 votes
Sam Harding Atlassian Team Dec 05, 2021

Hi @Rahul Singh 

I am not sure what you would exactly want in order to determine productivity on a particular story, but we do provide the ability in Automation to programatically see the values of the original estimate and the time spent.

We provide smart values on an issue {{issue.timetracking.originalEstimate}} and {{issue.timetracking.timeSpent}}, which return the relevant values. If you wanted to, you could for example send an email of all open stories on a daily basis, where there is a comparison of the original estimate and the time spent. This would be achieved by:

Trigger -> Scheduled Trigger (maybe set to daily)

Lookup Issues -> Do a JQL search for open stories

Send email -> Send an email with the estimates, for example

Here are the estimates for our open stories:
Issue: {{key}}
Original Estimate: {{timetracking.originalEstimate}}
Time spent: {{timetracking.timeSpent}}

Or, if you want to be more particular, you can do some logic here to get more relevant data. For example, if you wanted to only send emails about stories which have had more time spent on it than the original estimate, you can filter the lookup issues JQL search to add a condition where timeSpent > originalEstimate.

Hope that helps point you in the right direction


Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Apps & Integrations

Marketplace Partner Spotlight: Fine Software

Happy New Year, everybody! What better way to kick off 2022 than with a new Marketplace Partner Spotlight ✨ This month, we're getting to know Daniel Franz, co-founder of Fine Software. Fine Software ...

429 views 2 15
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