Jamie Farmer

Nice!  I might steal it!

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.  

I just used a filter for Ticket Created, yes.  

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

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?

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)