Hi there,
I am trying to set up a custom report that shows me which companies have submitted tickets over the last two years, and how many tickets per company.
I have managed to create a report that shows me the number of tickets in total per status, and the number of associated companies (see screenshot below).
I need to be able to see a list of the associated company names as I need to write a report providing a list of the number of tickets submitted over 2 years per company. How can I do this?
On another note, I’d also like to gather information from our tickets and create a list of the top 25 support issues we’ve had over the past 12 months. What is the best way for me to do so?
Thanks!
Dalene
Hi @DKlopper,
To add the company name, click ‘Edit data source’ in the top left corner and select ‘Companies’ as a data source. Once selected, you should be able to find ‘Company name’ in the left sidebar.
To only show the number of tickets from the last two years, look for the ticket ‘Create date’ in the left sidebar and add it to the ‘Filters’ tab. You can then filter for a create date range.
Let me know if you have any follow-up questions!
Thanks @karstenkoehler
I’d also like to gather information from our tickets and create a list of the top 25 support issues we’ve had over the past 12 months. What is the best way for me to do so?
Hi @DKlopper,
That depends on how you identify which issue a ticket corresponds to. How do you document / track that?
In any case, this information would have to live in a ticket property, e.g. ‘Category’. You would then create a report on tickets that displays the Count of tickets by Category and you filter the report by the Create date of the ticket (less than 365 days ago).
Best regards!
