Capturing metrics for leaderboard

[Kathy Barton]

I've started an initiative to encourage team members to put estimates on tickets and I want to generate some kind of "leaderboard". I also have a KPI tied to the initiative to improve this so I need to find a way to quantify my results. I'm trying to figure out how I can query Jira to find out how often someone had a ticket where the Original Estimate field was empty during a sprint but since the WAS operator isn't supported for that field, I am stumped. Has anyone figured out how to do this? 

TIA!

-Kathy 

[Iago Docando]

I tried something similar and what I'm monitoring are the issues where "originalEstimate IS EMPTY AND statusCategory!=TODO". You could choose yet many other options, for example "originalEstimate IS EMPTY AND createdDate<=startOfDay(-x)" where x is the maximum amount of days from ticket creation that you consider ok for the ticket to not yet have an estimation.

As far as the leaderboard... I'm guessing you want on the top of the table the people whose estimation has been closer to reality. You could do something like using a calculated field to return the absolute value of the remainingEstimation and sort the finished tickets (statusCategory=DONE / resolution IS NOT EMPTY / ... whatever works for you) based on that field.

I hope it helps :)

[Kathy Barton]

Thanks, I have the queries I need on dashboards that show the daily status. What I can't figure out is how I can get that historical data. I want my leaderboard to show people who have the fewest tickets that didn't have an estimate at any point during the sprint. Looking at how accurate they are will be the next step, once I can get people to actually enter them :p 

[Iago Docando]

Do you mean you want to be able to change dates in your leader board and watch the classification change aswell to show the rank at that particular date??? If so, that's impossible as far as I know.

I guess you *could* code an EXTERNAL tool that feeds from the API and reads into the changelog of every issue you want to track and then builds that "browsable" historical data... You could try something along the lines of

https://YOUR_JIRA/rest/api/2/search?jql=YOUR_JQL&fields=*all

It seems a bit overkill to me but... if you're willing to take the time I don't see any other option to get there.

Alternatively (I would follow this route) you can settle with the "current state dashboard" and simply send a monthly email to the participants with the monthly classification or something like that.

I hope it helps :)