Ability to exclude weekends or specific days from "time between" calculated properties

SamanthaA

It would be excellent to have the ability to report on a "time between" calculated property that permits the exclusion of weekends or certain dates and times. For example, for the HubSpot default ticket property "Time to close," it would be ideal to have the ability to edit this property OR create a custom calculated property that permits you to not include weekends. That way you could report on the days that passed between ticket creation and ticket closure in which your reps were scheduled to be actively working on the tickets.

10 Replies
Neidac21
Member

Thank you Sam excellent idea! it would be super useful in terms of measure the progress of our team

csims5290
Member

I agree! This is something we are currently struggle with, especially with the workflows that generate a due date.

BigeMe
Member

yes please!

Glennava
Member

This would be a great addition. The previous ticket platform that we used allowed this, and it was a free solution. Do not see why Hubspot does yet have this feature. 

 

Barbie
Member

We also struggle with reporting and workflows that don't allow us the option to exclude weekends from our reporting or days to start workflows.

d_neel
Member

I upvote & comment on this idea every time it pops up. 

MNorris
Member

This would be huge for my team. One of our metrics is time to close and the weekend hours for a ticket that was open on Friday don't accurately show the time they spent working on it

Mink_Webs
Member | Elite Partner

This feature would also be great for reporting for Response and close time for Service Tickets!

Vivi
Member

Excellent idea.

exlude week end, public holiday also.

AAdade
Member

+1

Ticket metrics and reporting are severely impaired without this context.