user reports

[sehrish_naaz]

Mostly we use bug tracking projects in our company. I've created different dashboards to get info about work progress. But, also I need periodic reports to get info about efficiency of employee (assignee), i need this information:

weekly reports of tasks assignede to the user

how much time they spend on last week 

[Petter Gonçalves · Accepted solution]

Hello @sehrish_naaz

Welcome to Atlassian Community!

Per your description, I believe you would like to have a report that will display the number of issues assigned in the last week for each user on your site and the time spent by the users on those issues. Is that correct?

You can achieve the count of issues using the Two Dimensional Filter Statistics gadget. These would be the steps:

- In your issue navigator, create the following filter:

assignee changed after startOfWeek(-1w) BEFORE endOfWeek(-1w)

- Navigate to your dashboard > Add the Two Dimensional Filter Statistics gadget, configuring it with the assignee field and status, using the filter you created:

It will display the count of issues assigned in the last week, including the status they are.

For the sum of time spent on the issues by each user, you will need a third-party app to have that information. The Time reports app to provide you with this information, where you can apply the same filter to the Pivot by Users report:

Let us know if you have any questions.

[sehrish_naaz]

Thank you!

I got my answer but please explain this JQL syntax

assignee changed after startOfWeek(-1w) BEFORE endOfWeek(-1w)

 how it works so I can apply more filter.