Hello, I’d like to create a report to see how long each ticket is in each separate ticket stage from our ticketing pipeline. …

Hi @Anonymous I would have suggested a similar approach to the one described in the community post that you have shared. You…

Ohh my bad, seems I have an Ops Hub Trial in my portal :roll_eyes: I would change this to “ticket status is known”, we want …

Hi @Anonymous Did some more thinking, think this should work: [Time in ticket stage - HubSpot Community (1).png] My think…

Hello, @Anonymous thank you for posting in our Community! I would recommend upvoting and leave your comment on the idea share…

Hi Frank, thank you for your solution! Indeed, the tickets do move backwards into the ticket pipeline sometimes. Would it be …

Hi @Anonymous Then it gets a bit tricky and my solution won’t work. From the top of my hat, the following could work but wou…

Hi Frank, Many thanks! This could work as a workaround solution for the time being. If I understand you correctly, ‘1’ mean…

Like this: [ASchipper_0-1690275841152.png]

[ASchipper_0-1690276413766.png] We do not have operations professional, so I’ve set the triggers to trigger every time when…

Thanks Frank, I’ll kindly await your reply in the afternoon.

The workflow is currently like this: [ASchipper_0-1690285152537.png] And the report like this: [ASchipper_1-169028517812…

Hi @Anonymous Yes, sorry if that wasn’t clear from my side. 1 means 1 day, the fractions were referring to a fraction of a d…

Create custom report for (average) ticket time per ticket stage

system July 25, 2023, 9:44am 14

How should I then display this information in a report? I’m having a hard time figuring this out.

Topic		Replies	Views
Time in Ticket Status reporting function HubSpot Ideas help-desk	43	20471	March 17, 2025
Time In {Ticket Status} Not Working Tickets & Conversations starter	16	11345	July 15, 2026
Calculate time spent in a stage for tickets Tips, Tricks & Best Practices best-practices	3	3293	March 17, 2025
Real Time in Ticket-Status reporting function HubSpot Ideas help-desk	9	2383	March 17, 2025
Time tracking movement of tickets by Status Tickets & Conversations help-desk	5	4872	March 17, 2025