How can I track personal OTD and Velocity? Edited

In our performance reviews we have performance objectives. One of these objectives is always something like "Achieve 85% OTD for projects, tasks, etc.". Basically, measure yourself in everything you do and let us know if you meet the objective.

What I have been doing for years is keep a seperate spreadsheet of tasks with columns like estimated completion date, actual completion date, estimated hours and actual hours. As well as a few other metrics not relevant to this.

Anyway, this gets tedious, especially since I use JIRA for time reporting as well.

If I can figure out how to run these types of personal analytics, then I think it would help me and other organizations that require employees to keep track of their own performance metrics.

Hopefully this is already available, but if not, can someone point me in the right direction using a custom search and/or gadget?

1 answer

This widget could not be displayed.

As it sounds you figured out the solution in Excel, you could have the Better Excel Plugin to fill that for you!

In nutshell, it allows putting placeholders in a regular Excel file and creating a so-called export template. Then the add-on replaces the placeholders with the actual field values from JIRA, plus utilize all advanced Excel features like functions, formulas, charts, etc.


Plus: as these reviews are periodical (I guess), you can make it 100% automatic. So JIRA will send you the ready made reports when it is time!

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

119 views 2 0
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you