You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I am trying to get the number of tickets that has A or B or C as one of the participants.
then I changed to
I supposed the 2 numbers would make up the total tickets, but the total service request should be 6000
what am I missing here?
should I just consider 6000-1811=4289 as the number of tickets that has A or B or C as one of the participants?
thank you in advance!
Welcome to the community. For your JQL queries, you should also consider to get a count where "Request participants" field is empty too. Lastly, when you obtained the count for all "Service Request" issue type issues, are you just using something like this query below? -
issuetype = "Service Request"
Hope this helps.
Best, Joseph Chung Yin
Jira/JSM Functional Lead, Global Technology Applications Team
hi Joseph, thank you for your reply!
the full query filter includes: project, issue type, participant, date range
if I understand you correctly-
1.participant include A/B/C (the 746 I mentioned above) + 2.have participant but participant does not include A/B/C (the 1811 I mentioned above) + 3.participant is empty = total ticket count
I got the 3 numbers and curiously the total is 11 less than when I totally removed the particpant filter
it will be great if you could share whats missing again but it should be close enough to give me an overview % already
thank you again!
You are using "In" and "Not In" when you querying for "Request Participant" field right. You can also use "Is" and "Is Not" to conduct your testing for Empty/Not Empty too.