Count the amount of values in a multi checkbox property
Hi HubSpot community,
We are currently testing the Ops Hub.
One use case I was hoping to solve with it, is the following. We want to introduce an Account health per customer. Therefore we would like to use available data in HubSpot. We are selling our core software with additional modules. In total we offer 10 modules. Now I would like to count the values being added per customer to calculate upsell potential.
E.g. We have 10 modules available, but a customer only uses 5. So in the field "Modules" on Company level, I would want to count the selected values and add them to a number field.
5 --> 5 out of 10 (50% coverage) / 6 --> 6 out of 10 (60% coverage)