I want to create a report that shows how much time each ticket owner spent on a ticket when there are multiple owners on the ticket.
Hi @SBash1,
As far as I know, this is not possible / not something that HubSpot is offering out of the box. You would have to look into time tracking solutions to achieve that: https://ecosystem.hubspot.com/marketplace/explore?eco_search=time%20tracking
Alternatively, you could create date properties for each ticket owner:
- Picked up by owner A date
- Handed over or finished by owner A date
- Picked up by owner B date
- Handed over or finished by owner B date
- etc
These would have to be set by ticket based workflows to log the current date whenever tickets are assigned.
You could then use calculation properties to calculate the time between each set of two: Create calculation and rollup properties
The risk here is that re-assignments to the same person would replace previous dates, not add to them.
Lastly, there is of course always the route of a custom development solution, based on the HubSpot API.
Best regards!