topic Re: Showing growth of a particular property? in Dashboards & Reporting

Showing growth of a particular property?

OliLittlejohn — Mon, 17 May 2021 09:57:49 GMT

Hi there, I'm hoping someone can help explain to me how I can use a Dashboard to show the growth of a particular property, ideally as a graph going up and (ideally) to the right 📈. For context, we work with a lot of startups, and we want to track the number of employees they have.

So say I was to have a property for a Company that is "Number of employees". What I'd like to do is show over time that across ALL the companies we work with the number of employees is going up. So the x axis would be time, the y axis would be number of employees, and the data would be aggregated across all Companies. Is this possible?

Re: Showing growth of a particular property?

karstenkoehler — Mon, 17 May 2021 11:58:54 GMT

Hi @OliLittlejohn,

I gave this some thought but I think it can't be done with HubSpot reports. HubSpot properties only let you access the current value of a property. Hence, reports can't plot property values over time.

There is a way to access this information via exporting the property history. If companies go through changes in "Number of employees", you would have that information in an exported Excel file and could visualize this it outside of HubSpot.

Best regards!

Re: Showing growth of a particular property?

OliLittlejohn — Mon, 17 May 2021 12:25:21 GMT

I was worried that might be the case. Seems pretty weird that you wouldn't be able to chart the progress your properties are making! Doubt I'll have time to export each company individually too 😞

Thank you for your speedy response!

Re: Showing growth of a particular property?

karstenkoehler — Mon, 17 May 2021 13:21:13 GMT

Hi @OliLittlejohn,

You can export the history across all records, you wouldn't have to do this record by record 🙂

Best regards!

Re: Showing growth of a particular property?

OliLittlejohn — Tue, 18 May 2021 08:03:22 GMT

Oh wow, that's really helpful, thank you! Good to know.

Re: Showing growth of a particular property?

Sokz — Thu, 08 Feb 2024 19:34:31 GMT

I am also looking to plot the history of a property on a graph