Recent searches


No recent searches

Jamie Farmer's Avatar

Jamie Farmer

Joined Oct 04, 2022

·

Last activity Apr 19, 2023

Following

0

Followers

0

Total activity

7

Votes

0

Subscription

1

ACTIVITY OVERVIEW

Latest activity by Jamie Farmer

Jamie Farmer commented,

CommentExplore recipes

Nice!  I might steal it!

View comment · Posted Apr 19, 2023 · Jamie Farmer

0

Followers

0

Votes

0

Comments


Jamie Farmer commented,

CommentExplore recipes

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,

CommentExplore recipes

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,

CommentExplore recipes

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,

CommentExplore recipes

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,

CommentExplore recipes

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