You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
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
I would consider simply using the created vs resolved dashboard gadget and the following filter
project = itsd and assignee in membersof(itsd)
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It looks fine to me, what does "it's not working" mean?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.