topic Capturing and Calculating the Difference in Value Between Two Property Updates in Dashboards & Reporting

Capturing and Calculating the Difference in Value Between Two Property Updates

PPenev_1 — Mon, 15 Jul 2024 10:39:49 GMT

Hi HubSpot Enthusiasts,

I am trying to figure out a way to capture and calculate the difference between the latest 2 value changes in the same property (screenshot below).

I'm trying to store the second to last change in an additional property, then use a calculated property to subtract the latest value from the second to last one and show the difference. I've tried multiple approaches but none of them worked.

Any Ideas?

Thanks in advance!

Re: Capturing and Calculating the Difference in Value Between Two Property Updates

karstenkoehler — Mon, 15 Jul 2024 11:02:38 GMT

Hi @PPenev_1,

This requires one additional property and workflow in the workaround you've already explored.

Let's assume your property is called 'Number'.

Create an additional custom property 'Number (delayed by 1 minute)'
Create a workflow that re-enrolls the record when 'Number is known', then delays 1 minute, then copies the value to 'Number (delayed by 1 minute)'
Create a calculation property, 'Difference (calculation)' to calculate the difference between 'Number' and 'Number (delayed by 1 minute)'
Create an additional property, 'Difference (static)'
Create a workflow that re-enrolls records when 'Difference (calculation) is known AND Difference (calculation) is not equal to 0', then copy the property value into 'Difference (static)'

One minute delay might not be enough, so you might want to try 2 or 3 minutes if it isn't working.

Have a look and let me know if you have any follow-up questions!

Re: Capturing and Calculating the Difference in Value Between Two Property Updates

PPenev_1 — Fri, 19 Jul 2024 07:07:58 GMT

@karstenkoehler Thank you so much! Your method worked like a charm : )