I need a report that contains the following columns:
Assignee (Group by)
Original Estimate (SUM())
Time Spent (sum())
Efficiency (Original Stimate / Time Spent)
Until now, I did not find any report with that collumns.
I am trying use the Klipfolio, but, the rest api only returned 50 issues max, and I need more than 50 issues for to do a calculation.
That said, I'm a little bit sceptical about "Original Estimate / Time Spent" being a valid metric for measuring people efficiency. It might require too many perfect conditions (not very realistic ones) in order to start being a meaningful indicator of accuracy of estimations, not to mention to start generating scientifically relevant data for measuring people efficiency...
In most cases, this metric will just tell you how good your estimates are, it's not going to give you "efficiency". Basing commission on it is going to give you one of two problems.
Exactly! If you would like to promote efficiency, I would try a plugin for introducing gamification into JIRA, like Jiraffe.
Giving points and badges is known to be a good way to improve participation and quality of contributions.
Please, do not use it to try to measure real effort, but just as a way that might help people to get motivated.
You can pretty easily get all this information through standard issue navigator. Make sure you have the following columns visible:
Export to csv, pull your data into a spreadsheet application and create a pivot right there. Or leave out Workratio and do your calculation in the spreadsheet.
Hi Walter, thank's for the anwser..
Is not there something more practical?
I currently calculate my team's commission based on efficiency, and would like something more visual where everyone can keep up with their work.
If you have not, do you have any tips on how I can resolve the issue limit of 50 results in api to use on Klipfolio?
Like photo bellow
You can easily create this report with the Better Excel Plugin.
For the "efficiency" metric you could use the built-in Work Ratio field, but there are other options:
For visuals, you can use standard Excel pivot charts like:
Disclaimer: I am developed working on this app.
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/startup.sh ExecStop=/opt/jira/bin/shutdown.sh TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...
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!
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