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

0 votes

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
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,162 views 5 10
Read article

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