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…

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, 10:17am 10

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

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