roll up lowest relationship health score as account health score

  • 1
  • Question
  • Updated 5 months ago
  • Answered
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?
Photo of Tony Tao

Tony Tao

  • 546 Points 500 badge 2x thumb

Posted 5 months ago

  • 1
Photo of Tim Schukar

Tim Schukar, Employee

  • 1,430 Points 1k badge 2x thumb
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? 
Photo of Tony Tao

Tony Tao

  • 546 Points 500 badge 2x thumb
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?
(Edited)
Photo of Tim Schukar

Tim Schukar, Employee

  • 1,430 Points 1k badge 2x thumb
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:

Photo of Tony Tao

Tony Tao

  • 546 Points 500 badge 2x thumb
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.
Photo of Tim Schukar

Tim Schukar, Employee

  • 1,430 Points 1k badge 2x thumb
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.
Photo of Dan Ahrens

Dan Ahrens, Official Rep

  • 24,642 Points 20k badge 2x thumb
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.