I am trying to create a report that tells me the average number of Jira ticket creations an agent does in a day from the Jira/Zendesk integration.
I have been looking at the below articles for refence.
https://support.zendesk.com/hc/en-us/articles/4419349462298-Explore-recipe-Reporting-on-Jira-tickets
I can create the standard calculated metric for the number Jira tickets created per agent, but I cannot figure out how to create this as a daily average. I feel like I am close, but nor there yet. Can someone please point me in the right direction? Thank you!
Have you tried dividing the ticket count by
DCOUNT_VALUES([Ticket created - Date]), similar to how the formula of the native metric Tickets created - Daily average? Alternatively, you can use this default metric, filter the report to only include those with the Jira tag, and then slice the report by agent name.