BTW, we tried to do this using the HubSpot API and Tableau.
The results were all jumbled, and we thought we must be doing something wrong.
We contacted support, who set-up a call with advanced support guy who told us the HubSpot API doesn’t always work, it misses dates and times.
This is probably why they don’t have this feature in place!
“That is honestly just the HubSpot Apis not returning data correctly. Some of the ones we use are still in beta.”