# Ticket Reporting

**URL:** <https://community.hubspot.com/t/ticket-reporting/95853>\
**Category:** Tips, Tricks & Best Practices\
**Tags:** professional\
**Created:** [December 12, 2023, 10:24am UTC](https://community.hubspot.com/t/ticket-reporting/95853 "2023-12-12T10:24:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![DKlopper](https://avatars.discourse-cdn.com/v4/letter/d/b19c9b/32.png) [@DKlopper](https://community.hubspot.com/u/DKlopper)\
**Post date:** [December 12, 2023, 10:24am UTC](https://community.hubspot.com/t/ticket-reporting/95853/1 "2023-12-12T10:24:05Z")

</div>

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

 ![Ticket Report.jpg](https://d2qpr2jzcazej7.cloudfront.net/original/2X/1/1b23109279d4ec92b5ac59672d6f1cb4affec4e7.jpeg)

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [December 12, 2023, 10:27am UTC](https://community.hubspot.com/t/ticket-reporting/95853/2 "2023-12-12T10:27:13Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![DKlopper](https://avatars.discourse-cdn.com/v4/letter/d/b19c9b/32.png) [@DKlopper](https://community.hubspot.com/u/DKlopper)\
**Post date:** [December 12, 2023, 10:38am UTC](https://community.hubspot.com/t/ticket-reporting/95853/3 "2023-12-12T10:38:57Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [December 12, 2023, 10:41am UTC](https://community.hubspot.com/t/ticket-reporting/95853/4 "2023-12-12T10:41:21Z")

</div>

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!