Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Alyse Weatherford May 25, 2018 edited

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 edited

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
TAGS
atlassian, ace, atlassian community event, donation, girls who code, women in tech, malala fund, plan international, kudos, community badge, badge, atlassian badge, International Women’s month, International Women’s Day, women's month, women's day

10 for Change at Atlassian Community Events

Show up and give back by attending an Atlassian Community Event: we’ll donate $10 for every event attendee in March!

Join an Atlassian Community Event!
AUG Leaders

Upcoming Jira Events