hi everyone
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!
@JQ -
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
Viasat Inc.
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 must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@JQ -
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.
Best, Joseph
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.