You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Cannot Nest Aggregate Function or Use On Aggregate Column

edited Jun 16, 2017 4:44PM in Reporting & Analytics for B2C Service 6 comments

Content

Hi all,

I am trying to create a dashboard that will give information based on incidents that were manually categorised vs what goes through our automated categorisation rules. To do this I first need to calculate how many incidents were manually categorised and how many were autocat. The autocat is super easy to do as there is a custom field on each incident that is updated if it hits the autocat rules. Manually categorised is a different story. I figured that the best way to get this number is to count this expression:

“if(first(queues.queue_id, transactions.created) = 18, incidents.i_id)”

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!