Report on Time between two dates

Smart CRM & Sales Hub Dashboards & Reporting
1

Hello,

I have two date properties that I created.

Some of my employees are responsible for multiple contacts. I want to see how long it takes each manager on average to get the contacts he/she is responsible for between the first date property and the second date.

How do I create a report showcasing this?

2

Hi @maulpaurer,

This can be achieved with a calculation property: Create calculation and rollup properties

Select duration as a number format and specify your two date properties.

Once created, you can create a single object or custom report builder report, and visualize this new property by record owner. Select average as the measure for the new property and you should see the average duration by owner.

Best regards!

3

Thanks for the quick answer.

Is it possible to achieve it only using the reporting functions provided by hubspot, as we are limited with calculation properties

Thanks in advance

4

@maulpaurer only using Operations Hub Professional and formula fields in reports. Do you have that subscription?

5

I have Operations Hub Professional, so it should work, right?

6

@maulpaurer yes, you can find instructions here: Build and activate datasets in Data Studio

The article also explains formula fields.