When pulling Deal-related metrics from HubSpot into Databox, you might notice that duration values (like deal age or time in stage) are displayed as extremely large numbers. This happens because HubSpot provides duration in milliseconds, while Databox expects durations in seconds.
Fortunately, there’s a simple fix to convert the data properly.
How to adjust duration values from HubSpot
Navigate to Calculated Metrics and create a new Calculated Metric.
Take the Metric you're pulling from HubSpot (e.g., "Time to Close")
Divide the value by 1000 to convert from milliseconds to seconds
Example formula: [HubSpot Duration Metric] / 1000
Apply a Duration Format
After creating the Data Calculation, apply the Duration format in Databox.
This will correctly display the value as days, hours, or minutes instead of raw seconds or milliseconds.
This quick adjustment ensures your time-based Metrics from HubSpot are accurate and easy to interpret in your dashboards.
For more on setting up Data Calculations, visit: How to create a Data Calculation.