Cannot Nest Aggregate Function or Use On Aggregate Column
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)”
Tagged:
0