I have created a standard calculated metric in the ticket updates dataset using a numeric custom field:
The metric follows the same logic as the Zendesk standard metrics (e.g., Tickets created):
If I apply this to the data of one individual day it returns a number, however, as soon as I include data of more then one day, no data is returned and I get a warning that the SQL query returns more than 50000 rows.
Does anyone have an idea why this is not working? Is it possible that this has something to do with "ACD Anzahl Outboundcalls" being a "numeric custom field" and not a "ticket custom field"? And has anyone any ideas how to fix this? I have tried limiting the custom metric to only tickets that have an entry in this field but so far haven't had any success.