How to create a report containing a % of times going into one status(revision) vs Done

[George Apostolopoulos]

So I am trying to create a report that allows me to see the percentage of the number of times a task has entered the swimlane ('Revision' in this case)  for a team member that had the task assigned to them vs the task itself going in 'Done'. so for example if Jeff had 3 tasks completed but 1 required a revision the 1/3 = ~ 33% of his tasks for this sprint required a revision

[Jack Brickey · Accepted solution]

there isn't anything out of the box for this. You can consider a marketplace app such as easyBI or simply export to Excel or Microsoft PowerBI.

One possible solution you could consider is leveraging automation and adding a label to any issue that enters the revision status. Then you could create a filter that illustrates all issues assigned to an individual comparing those with the label in those without. To add a little more reliability this solution you could create a custom build specifically for capturing issues going into revision. If you are interested in this approach and give it a try let me know if I can assist.

[George Apostolopoulos]

I think I'll give it a shot! thank you!

[Trudy Claspill]

As @Jack Brickey noted there isn't anything built-in for this, but you could write queries to get the list of issues, from which you can get the counts.

Assuming Revision is a value for status, you can execute a query like this to find how many issues assigned to person X were in that status at some point:

project=<yourProject> and assignee=<the Assignee> and status was Revision order by created DESC

 And then for getting all the issues Done:

project=<yourProject> and assignee=<the Assignee> and status = Done order by created DESC