Recent searches
No recent searches

Jamie Farmer
Joined Oct 04, 2022
·
Last activity Apr 19, 2023
Following
0
Followers
0
Total activity
7
Votes
0
Subscription
1
ACTIVITY OVERVIEW
BADGES
ARTICLES
POSTS
COMMUNITY COMMENTS
ARTICLE COMMENTS
ACTIVITY OVERVIEW
Latest activity by Jamie Farmer
Jamie Farmer commented,
0
Followers
0
Votes
0
Comments
Jamie Farmer commented,
Ahh...actually, my report is a little different. I only wanted to see orgs with no URGENT tickets. So, my report has total tickets column and a URGENT tickets column. However, I just now tried without the URGENT, and it only shows orgs with ticket count greater than 0 once I use date filters. So, looks like I am seeing the same results as you when trying to only see that info.
Maybe Phil Clark is still around? Looks like his original request was the same as yours (without date). I don't see Gab Guinto when I search.
View comment · Posted Apr 19, 2023 · Jamie Farmer
0
Followers
0
Votes
0
Comments
Jamie Farmer commented,
I just used a filter for Ticket Created, yes.
View comment · Posted Apr 19, 2023 · Jamie Farmer
0
Followers
0
Votes
0
Comments
Jamie Farmer commented,
Yes, they assigned a ticket 10918177 , and I was able to get it to work by using these Metrics:
COUNT(Tickets)
COUNT(Urgent_Count)
D_COUNT(OrganizationsCount)
Urgent_Count is IF [Ticket priority]="Urgent" THEN [Ticket ID] ENDIF
OrganizationsCount is IF ([Ticket organization status]="Active")
THEN [Ticket organization ID]
ENDIF
View comment · Posted Apr 19, 2023 · Jamie Farmer
0
Followers
0
Votes
0
Comments
Jamie Farmer commented,
Thanks, but I'm still struggling to get it to work with any date filters. The below is accurate, but has no date filters.
But as soon as I try and add a date filter, it's incorrect.
Does the date filter also need to be custom?
View comment · Posted Oct 20, 2022 · Jamie Farmer
0
Followers
0
Votes
0
Comments
Jamie Farmer commented,
I'm trying to build off of this to capture Organizations who have submitted no Urgent tickets, within a certain timeframe. I was hoping I could just use filters, but when I add any Date or Ticket Priority filters, it no longer shows correctly. Is there a way to capture this information, and preferably still allow it to be dynamically filtered? (i.e. different date range, or different priority)
View comment · Posted Oct 04, 2022 · Jamie Farmer
0
Followers
0
Votes
0
Comments