Dashboard to show Top 3 resolved tickets of the week - assignee. And current most assigned tickets.

[Rithvik Banka]

I want to make a dashboard to show Top 3 most resolved tickets of the week for assignee in the team. And current most assigned tickets. Where I can award the candidate for most resolved tickets and also show the most assigned tickets currently. 

I tried using 2D gadget, but it doesn't work. Meanwhile I tried this filter,

filter in ("PROJECT") and status = Resolved and resolutiondate <= now() and resolutiondate >= endOfWeek()

But i can't get the data for these filters. Can you help me with this?

Thanks in advance.

[Jeroen Poismans · Accepted solution]

Hi Rithvik and welcome to the Atlassian Community!

I don't know what you are trying to to get out of this JQL, but there is something in there that in my opinion will nver show issues:

resolutiondate <= now() and resolutiondate >= endOfWeek()

What you are saying here is that you want issues resolved prior to today but after the end of the week? Is this a typo perhaps?

Have a look at some extra info about JQL and the dates used in JQL:
https://support.atlassian.com/jira-service-management-cloud/docs/use-advanced-search-with-jira-query-language-jql/

Jeroen

[Rithvik Banka]

Many thanks @Jeroen Poismans for speedy response.

1. I want to know the percentage of all issues resolved during a week by assignee. Basically, this is to help me know the completion rate for each assignee in a Week.  E.g., Assignee "X" had 3 issues at the start of Week and completed 1. And assignee "Y" had 4 issues at the start of Week and completed 2. The completion rate for Assignee A is 33% and B is 50%.
2. I want to know the number of tickets assigned currently to each individual assignee. E.g., Assignee "X" has 2, "Y" has 2, "Z" has 5 pending tickets.

I would be glad to know if there is another way to get this information. 

Regards,

Rithvik Banka