I would like to produce a dashboard showing each team member and the number of tickets they have worked on for the last 6 months, and I am looking for the filter to do this?
Hello @Jake S
What is your definition for "worked on"?
Do you people log time against issues? Is the definition of "worked on" any issue against which they logged time?
Or does "worked on" mean that at some point the user was the Assignee on the issue?
Hi @Jake S ,
I have the same questions as Trudy... but I wonder if this may address your use case:
assignee was in (<user>) and status WAS "In progress" BY (<user>) After startofmonth(-6)
At some point the user was the Assignee on the issue
I tried that, however it will only return the ticket once if 4 people in the IN statement have been assigned to it. Where I would like a the ticket returned 4 times, once for each person it has been assigned to, or a count for each person
Hi @Jake S
If you want to create the dashboard that works for everyone in the team, use in the filter "@currentuser" - then everyone that opens the filter will the themselves as e.g. assignee.
Steps to create dashboard"
- filter out the issues that met your criteria (e.g. "assignee was currentUser()")
- save the filter and change permission for more people to see it
- embed the filter into dashboard with e.g. "Filter result" Gadget
- save and share the dashboard - remember to change permissions of the dashboard as well
As suggested by @Natalia Cholewa you can use the "currentUser()" criteria to make a single dashboard that will show the data relevant to the user currently viewing the dashboard.
And as suggested by @Carlos Garcia Navarro you can use the WAS operator
assignee was currentUser() after startOfMonth(-6)
If you want a single dashboard that has the metrics for each user then you would need to create a filter that names each individual user, and reference each filter in a separate gadget to show the metrics for one user at a time.
There is not a native gadget that would show you the metrics for all the users at once, for every user that had every been assigned to each issue at some point in the past 6 months.
It looks like you're new here. Sign in or register to get started.
