Average time to close reports - closed date

Hi! We are using an HS-premade report for our onboarding KPIs that measure the time to close for each ticket. The report seems to be based on the create date, but I was wondering if there was any way to display the closed date instead?

Hi @MLatulippe,
Thank you for posting in the Community :slightly_smiling_face:
I would like to invite a couple of subject matter experts to this conversation: @Bryantworks, @Franci and @NicoleSengers: have you already made such a report? Do you have any tips on how to achieve this report, please?
Thanks and have a lovely day!
Bérangère

Hello @MLatulippe,

Please follow the screenshot below for the correct setup.

.1 Create a Custom Ticket Report

.2 Select the Table Chart

.3 Add the following properties:

  • Ticket Name
  • Time to close
  • Pipeline → This is useful if you have more than one pipeline

.4 Save and publish report

Please let me know if you have any questions!

Thank you @BérangèreL for mentioning me.

FrancescoCollaccianiSpecialista HubSpotExelab
francesco.collacciani@exelab.com
exelab.com

Hello @MLatulippe,

If my answer helped solve your problem, you can accept my reply as a solution. This will help others find the answer.

Francesco

.CollaccianiHubSpot SpecialistExelab
francesco.collacciani@exelab.com
exelab.com