Grouping of Property Values in Custom Reports

HubSpot Ideas
21

Agree!

I’m struggling with grouping ARR into tiers when creating a report. Since the ARR can vary (there are +150 variations) I would like to group it like <10k, 10-20k and >20k

Similar to the above would be to group our property Subscription Products (what customers are subscribing to) - we have +100 variations. So to be able to cluster them into the package names would be very convenient and intuitive when displayed in a report.

22

Hey @ALivåg & others,

While waiting for them to add a native report builder solution, I came up with an alternative using “Calculation” properties. E.g with the “Days to close” property:

if(
 [properties.days_to_close] <= 7, "1 week",
 if(
 [properties.days_to_close] <= 14, "2 weeks",
 if(
 [properties.days_to_close] <= 30, "+1 month",
 if(
 [properties.days_to_close] <= 60, "+2 months",
 if(
 [properties.days_to_close] <= 90, "+3 months",
 if(
 [properties.days_to_close] <= 180, "+6 months",
 if(
 [properties.days_to_close] <= 365, "+1 year",
 ">1 year"
 )
 )
 )
 )
 )
 )
)

You can then use this newly created property in your reports. Hope this helps!