It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Report for completed task by user wise

Hi

Is there any way to get a report by user wise completed task. I have used to filter the issues by done status and it gives me all the done issues. But the problem of this report gives me the done who lastly updated. Please  refer the following example,

Task: Login page create

Workflow: To do -> Development -> QA -> Done

1. Assign this task to my developer: user - A

2. After development this task going to QA: user B

3. After QA completed user B transfer task to done status.

 

When I'm getting a report for this project user wise done status it gives me all the done status with user "B". I wanted to see how many tasks have been completed or have been participated by all the users. Example task I have mentioned above have been participated by two users. User A and B.

I hope you all can understand what my requirement is.

 

Thanks

 

1 answer

1 accepted

0 votes
Answer accepted

Hi @Thiwanka ,

Try to use this JQL:

status = Done AND assignee was in (User1,User2,...)

Or this one:

status = Done AND assignee was in membersOf("GroupName")

This will return all the issues which was participated by one OR more than one users.

Not like this. Because if I get the done status it will show me who completed the task. I wanted to see the participated users for that particular task. Then only I can get the report with each user task list he has participated.

According to the above example,

if I wanted to check how many task have been participated by my developer for a particular period, where can I get? or how can I get that report? If I selected done status, all my done task comes with QA user. because the task has been assigned to the QA user before it has changed the status to done.

Your first question is to see how many users have been participated in all issues. I guess Jira doesn't provide reports like this, you should create it yourself. For example:

- Add a multi user-picker custom field to your project, (e.g. Field A)

- Add Post Function: "Copy Value From Other Field" , To each transition that you want to track their assignees, (Source field is Assignee, and Destination is Field A ). Each time that your specific transition is passed, previous assignee will be added to Field A and you can see all assignees in this field.

To do this, I think you'll need to have JMWE add-on, or JSU, etc.

- Now you are able to search for each user in all statuses using JQL like this:

"Field A" in ("User1")

 

For second report [how many task have been participated by User1 for a particular period] you can simply use this JQL:

assignee was User1 DURING (2019-03-27 , 2020-03-27) and status = Done

I hope this helps.

Thank you for your feedback. I will try and get back to you with the result.

Hi

Thank you for your suggestion. I have added a custom field called "Developer" for the screen. So, I can add my developer to a specific task. 

Capture.PNG

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Posted in Jira Software

Metrics Fun: 2019 in Review

Hello, Atlassian Community!  I thought it would be fun to do something different for my teams' last retrospective of 2019 so I'm planning to do a "year in review" with info-graphics.  Wha...

1,868 views 10 14
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you