Is there any way to create a rule to add a column to my reports in order to group accounts by specific data? I would like to create a formula that looks at # of employees field on the account object and buckets the account based on segment.
Best answer by keith_mattes
View original
+5
I don’t know if this helps but Row Grouping is an option based of already existing fields:
It sounds like you were looking for a way to group accounts with a range of numeric values (e.g. # of employees 1-100, 101-500, 501-1000) and have that be a brand new field/value in reporting?
Yes, trying to create new fields that will pull into a single column in reporting based on # of employees.
+2
Maybe create custom field on your company object for “Employee Count Band” and then add a new drop-down list of values for your employee “banding” levels and then create a rule to pickup that value based on the ranges you desire against the source data and that should do it ???
I also think GS has some built in banding usually applied to ARR and market segmentation that could potentially be leveraged as well. Hope this was helpful? :)
Thank you
+2
If you want/need to chat, please let me know in case I didn’t provide enough detail 
Happy to help out if I can!
+1
Maybe create custom field on your company object for “Employee Count Band” and then add a new drop-down list of values for your employee “banding” levels and then create a rule to pickup that value based on the ranges you desire against the source data and that should do it ???
I also think GS has some built in banding usually applied to ARR and market segmentation that could potentially be leveraged as well. Hope this was helpful? :)
Thanks, Keith for your response, today leveraging rules to populate the field is the way for this.
+1
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
