Client Work

Calculating if a Ticket’s SLA was met using Custom Coded Workflows

Written by On The Fuze | Jan 12, 2024 7:01:13 AM

 

Solution

First, we defined the workflow’s process…

Our HubSpot Specialists created two workflows to calculate the time it takes for a ticket to change stage and verify if it complies with the SLA time.

This is what it looks like…

Workflow 1: Get Ticket Stage and Start Time 

The first workflow marks the time the Ticket entered the current stage and saves them in other properties.



Workflow 2: Compare Time Spent with SLA Time

The second workflow compares the time the Ticket moved to another stage, calculates how long it spent in the previous stage, and then compares it to the SLA time.

 

Client Quote

 

“We demoed the solution and it went well!”