If you have a way to identify which shift/region took a ticket, this would be possible!
For example, if you are measuring all tickets created from 9am-5pm as shift 1, tickets created from 5pm-1pm as shift 2, and tickets created from 1am-9am as shift 3, you could make a Custom Group where you group together the Ticket Created - Hour attribute into those groups. This would be in the Tickets dataset. Then, you could measure tickets per those groups by simply have COUNT(Tickets) as the metric and your custom group as either the Column or Row attribute.
If you have a ticket field for the shift/region, you would simply use COUNT(Tickets) as the metric and then use that ticket field as the Column or Row attribute.
Hope that helps! Thanks!
Explore Recipes AMA has ended and comments have now been closed. If you have any Explore recipe related questions, you can create a new post in our Explore - Troubleshooting and Q&A topic!
Post is closed for comments.