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 vote

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.

See: http://www.midori-global.com/products/jira-better-excel-plugin/

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Jira Service Desk

Wy are we still using email for Service Desk workflows?

...attest to the experience of an urgent approval that gets lost in the boss’s inbox and requires that special “Please Approve” email or text message. In an age where we have distributed teams...

91 views 0 2
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