Hi ZD Team,
I'm hoping you can help me understand how to slice out data. I've been trying to sort this out for around a week now, and think I just need some general guidance to get me to where I need to be.
I'm trying to create a Line chart (or table), that contains the following information...
1. Count how many tickets solved that month (easy enough).
2. Count how many solved tickets during the month had a company Live date (custom field), that matches that month
3. Count how many solved tickets came from organizations with a Live Date that doesn't match that month
4. How many organizations have a Live Date that matches that month. (Basically a count of how many companies went live that month, we have a custom field for this).
I can generate this information using filters on a monthly basis, but haven't figured out how to get a year long monthly view. I think part of my problem may be that #1-3 come from the main Tickets Dataset, and #4 may need to come from Ticket Events or Updates.
Tl;dr: Need to take # of solved tickets and split them out a monthly basis based on custom fields.
Cheers and thanks!
Por favor, entrar para comentar.