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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

help create filter to view team's tickets

Hi Team,

I need to create a filter/graph that will show all the team members in ITSD (my group) and how many tickets were closed and are open in the last 7 days. This is what I have right now but it is not working. Please advise. 

 

project = ITSD AND status in (Closed, Done, "In Progress", New, Open, Resolved) AND assignee in (5c80631a3fb39d723db26280, 5bd8c46d6eeeee38037b74df) ORDER BY created DESC

4 answers

2 accepted

1 vote
Answer accepted
Jack Community Leader Feb 15, 2021

I would consider simply using the created vs resolved dashboard gadget and the following filter

project = itsd and assignee in membersof(itsd)

0 votes
Answer accepted

Hi Pammi Khann and welcome,

Created VS Resolved gadget will show the information you are looking for, but it needs an underlying JQL filter to pull the data.

QD1WmBF

Are the person of your team grouped somehow? If so you can do the following (supposing they are in a jira group already)

project = ITSD AND assignee in memberOf("group-name")

 

You can learn more about JQL functions at the following link:

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/

...and about Dashboard & gadgets here:

https://support.atlassian.com/jira-cloud-administration/docs/use-dashboard-gadgets/

 

Kind Regards

Hello Jack,

All the user names of people are under the ITSD project group. I think we are close but its not showing me the name of the people, how many tickets they have closed and remain open, etc. Please see the query below and also the pic:

project = ITSD AND status in (Closed, Done, "In Progress", New, Open, Resolved) AND assignee in (5c80631a3fb39d723db26280, 5bd8c46d6eeeee38037b74df) ORDER BY created DESC

 

 

filter.JPG

0 votes

It looks fine to me, what does "it's not working" mean?

please see below. I am able to put the chart together but i dont want it like that. I want to show the following:

John Smith  - Open 50 - Closed 50 

So the management can see how many tickets were closed by a particular person in the last 7 days and how many are open for that person. 

filter.JPG

As far as I know, there isnt any created vs resolved (by person) chart only the one I pointed out in my previous comment. That's the closer you can go I think.

Jack Community Leader Feb 16, 2021

consider using two-dimensional filter. you can't get just the two open/closed categories but you could use Status or Resolution. If Status Category were an option you could boil it down to three - to do, in progress, done, but that option isn't available either.

understood. thank you both so much.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS

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