Need to know how to see the number of projects assigned to a given Business Analyst per month?

Alyse Weatherford May 25, 2018

I need to see the number of projects assigned to a given BA per month

1 answer

0 votes
Javi
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 25, 2018

Hi Alyse,

By projects, are you referring to Jira issues? If so, you can run a JQL query to find out how many issues were assigned to a user per month. 

Below, I have provided an example of what this would look like:

assignee  = username AND createdDate >=  startOfMonth()  AND createdDate  <=  endOfMonth() 

If you are looking for the project lead, you will have to run a query on your database such as the following:

select * from project where lead = '<username>'

Let me know if this helps

Regards,
Javier A.

Alyse Weatherford May 25, 2018

Yes, I do mean issues. Thank you, I will give this a try! 

Alyse Weatherford May 25, 2018

Is there a way to see when a user becomes the business analyst of an issue? or when an issue goes from in progress to QA? I am looking for an exact date. 

Suggest an answer

Log in or Sign up to answer