As a concept, the calculation properties in Hubspot are phenomenal. However I have struggled a bit when trying to create a calculation property for a company, that returns the average of a contact property of the associated contacts. As an example, I might have a company that has 20 contacts associated with it. In my Hubspot account, I have created a custom contact property where I send an engagement score between 0 to 100, from an external engagement scoring tool. I have set up a calculation property for my companies where it calculates the average engagement score for all associated contacts. However, of the 20 contacts mentioned in the example above, only 10 of them are still working in the company. The remaining 10 should not be included in the calculation, as they all have an engagement score of 0 and will skew the results. In order to work my way around this, I have created a property called "status" which is either active or inactive. What I propose as an idea is to add a filter option to the average calculation, and only include contacts with a specific property equal to a specific value. If this was possible, I could set up the same calculation property, of the average type, and then say average health score for all associated contacts where status = active. In this example, only the health score of the 10 active contacts will be added to the average calculation, and the results would be accurate.
...read more