Ability to bucket values in Reporting

This would be huge for our product!

Depending on the exact use case, there might be options to use Data Designer to handle the formulas and grouping. 

Would also love to see this added. This is something that we use quite often in SF and would go a long ways in helping us start to make Gainsight our new reporting central. 

Another +1 for this feature. We’ve had a few requests lately to move some current Salesforce dashboards into Gainsight (yay!) because that is where our Exec team wants to work but we’re unable to recreate a few of their reports without adding additional fields and ‘calculating’ the buckets that way. One specific example...we have a list of 8-10 ultimate churn reasons and want to classify those into Preventable and Non-Preventable on a line chart.

Is this going to be part of Horizon Analytics? This has always been a pain point for me, but I’ve always been on the SFDC edition and just used Salesforce reports instead. Now I’m at a new company where I can’t do that because of NXT and relationship data that exists only in Gainsight. I want to do basic things like create a pie chart for our relationships that are onboarded vs not onboarded depending on the relationship stage, or the percentage of customers that have a CSM assigned vs not. Right now my options are

1. Give up on percentages and beautiful graphics and just create a dashboard of pure widgets. Eg: Total customers, # customers with CSM, # customers without CSM → tell our executives to do the math themselves to find the percentage
    
2. Export out of Gainsight and do everything in spreadsheets
    
3. Create custom fields and rules for every bucket we want to look at. I feel like this is probably what I will have to, but I’m not happy about it because it feels like unnecessary overhead AND because the data won’t even be “live” - it will be dependent on a rule schedule to update so inevitably someone will complain about something being mislabeled in the wrong bucket in a report because it hasn’t updated yet.

Other things I considered:

-calculated field on the relationship object. Advanced formulas where I could use case expressions only seem available on number and currency type fields though

-real-time rule that could update the bucket field (so basically #3 but the data would be live). However, can’t update any Gainsight objects right now in real-time rules, it’s insert-only on low volume objects

-I thought maybe I could use the same Alias on a report, if I just gave the same Alias to multiple values that would work as a bucketing system, however that is not allowed.

Am I missing something? Because something that would take me minutes to do in SFDC is making me want to cry and pull my hair out in Gainsight

This has the status of planned - will it be part of Horizon Analytics? I need to know whether I have to go build a bunch of custom fields and rules or whether I can hold out a little longer for Horizon Analytics. This is so desperately needed.

@mindym I will conclude with the product team once again and get back to you on this.