How to Report SLAs in Business Days in HubSpot
To report SLAs in business days in HubSpot, use NetworkDays' free Calculate Business Days workflow action to count the working days from ticket create date to first agent reply date or close date. Save the action output to a numeric ticket property with HubSpot's native "Set property value" action, then build your SLA report from that property.
HubSpot's native SLA feature measures SLA hours based on the operating hours configured in your help desk. It can exclude time outside those operating hours, including weekends if your schedule is set that way, but it has no public holiday support and does not return elapsed business days. NetworkDays calculates a real business-day number that you can store on each ticket and use in reports.
Step by step
-
1.
Install NetworkDays and set your country Authorize NetworkDays in your HubSpot portal, then choose the country whose weekends and public holidays should be excluded. The Calculate Business Days action is available on the free tier.
-
2.
Add Calculate Business Days to a ticket workflow Create or open a ticket-based workflow, then add the NetworkDays Calculate Business Days action where both SLA timestamps are available.
-
3.
Map the SLA start and end dates Set Start Date to the ticket
createdate. For a first-response SLA, set End Date tofirst_agent_reply_date. For a resolution SLA, useclosedate. -
4.
Save the result to a numeric ticket property Add HubSpot's native "Set property value" action immediately after the calculation. Choose a numeric ticket property, for example
nd_sla_business_days, and set its value to the Calculate Business Days output using the token picker. -
5.
Report on the saved business-day value Use the numeric property in HubSpot reports, filters, lists, and workflow branches. Compare it with your SLA target to group tickets as met or missed in business days.
Native HubSpot SLA hours vs NetworkDays
| Approach | Counts business DAYS | Excludes weekends | Excludes holidays | Effort |
|---|---|---|---|---|
| Native HubSpot SLA hours | No, it measures SLA hours | Yes, through configured operating hours | No | Low |
| NetworkDays | Yes | Yes, automatic | Yes, based on your selected country | Low, install and add two workflow actions |
Use HubSpot's native SLA feature when the target is measured in operating hours. Use NetworkDays when the report must show a count of business days and exclude public holidays.
Common questions
- How do I report an SLA in business days in HubSpot?
- Run NetworkDays' Calculate Business Days action in a ticket workflow, using ticket create date as the start and first agent reply date or close date as the end. Save the output to a numeric ticket property with HubSpot's "Set property value" action, then use that property in your report.
- Does HubSpot SLA support holidays?
- No. HubSpot's native SLA feature calculates SLA hours from your configured operating hours, but it does not exclude public holidays. NetworkDays excludes weekends and the public holidays for your selected country.
- How can I track a ticket SLA excluding weekends in HubSpot?
- Map the ticket create date and the relevant reply or close timestamp into Calculate Business Days. Weekends are excluded automatically, and the returned business-day count can be saved to the ticket for reporting.
- Can I report both first-response and resolution SLAs in business days?
- Yes. Use one calculation from
createdatetofirst_agent_reply_dateand another fromcreatedatetoclosedate. Save each result to its own numeric ticket property so you can report on both SLA measures.
Written by Sharoze Iftikhar, RevOps consultant and creator of the NetworkDays business days calculator.