We utilize the relationships feature to keep track of many programs that customers are running with us. Every program is important but if one program is red we would rather know the account is red - showing the account has important action items and may be at risk.
Is there a way I can roll up the lowest relationship score as the account overall score? What does that configuration look like?
Solved
roll up lowest relationship health score as account health score
Best answer by dan_ahrens
Tim's on the right track here - using a bionic rule you can apply the MIN function to aggregate all of the relationship scores and set the account level score (or metric) to the lowest of the relationship scores.
Hey Tony -
If you check "Enable overall rollup" on the Relationship Scorecard, you can set an exception that will change the overall health of the relationship based upon one measure alone (e.g. Red score of 1). From there, you can use the rules engine to check all relationship scores and determine if any of them = 1, then set the main company scorecard to red as well.
Let me know if you have questions on this?
If you check "Enable overall rollup" on the Relationship Scorecard, you can set an exception that will change the overall health of the relationship based upon one measure alone (e.g. Red score of 1). From there, you can use the rules engine to check all relationship scores and determine if any of them = 1, then set the main company scorecard to red as well.
Let me know if you have questions on this?
Hey Tim,
Thanks for the response.
I've checked "enable overall rollup"
What do you mean by "set an exception that will change the overall health of the relationship based upon one measure alone (e.g. Red score of 1)." Where can I do so?
Thanks for the response.
I've checked "enable overall rollup"
What do you mean by "set an exception that will change the overall health of the relationship based upon one measure alone (e.g. Red score of 1)." Where can I do so?
There is now an "Exceptions" tab next to the Overall Scorecard section. If you click on that, you'll get a pop-up that will allow you to select a measure and criteria to set overall score to red:
Ah Thanks. However, It seems that I have to select a specific measure, but I'm looking to have the overall lowest relationship score to equal the account score, not a specific measure. That doesn't seem to be an option, Right? I assume that creating an exception for each measure wouldn't make sense too.
Ah - you could still do this with Bionic Rules. You could pull a data set of all relationship scores across an account, find the lowest score and then set the score of the main account scorecard to that score.
+2Tim's on the right track here - using a bionic rule you can apply the MIN function to aggregate all of the relationship scores and set the account level score (or metric) to the lowest of the relationship scores.
VP of Customer Success at Forcepoint
Sign up
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.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.