ScoreCard 2.0 Exceptions

  • 5
  • Idea
  • Updated 2 months ago
  • Under Consideration
On our Scorecards, we have a measurement "Usage" which is calculated by two Sub Measurements "Call Volumes" and "User Volumes".  As with the overall account healthscore, we would like the ability to add an exception so that if EITHER Call Volumes or User Volumes are red, Usage is automatically set to red.
Photo of Jon Harris

Jon Harris

  • 322 Points 250 badge 2x thumb

Posted 2 months ago

  • 5
Photo of Aditya Marla

Aditya Marla, Employee

  • 2,294 Points 2k badge 2x thumb
Hi Jon,

Thanks for sharing this. If i understand correctly, you want to be able to define exceptions for "Group Scores" as well (today you can only define exceptions for the Overall Score)
Photo of Jon Harris

Jon Harris

  • 322 Points 250 badge 2x thumb
Exactly right!
Photo of Mark Gecsey

Mark Gecsey

  • 484 Points 250 badge 2x thumb
I would second that request. We have a specific need for that as well.
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 9,960 Points 5k badge 2x thumb
Hi All, This is a valid request.We have added this to our product backlog.
Photo of Dan Ahrens

Dan Ahrens, Official Rep

  • 23,636 Points 20k badge 2x thumb
Hi Jon, interesting use case here. Is it fair to say that what you are looking for is a MIN function on that group such that the score for the group represents the lowest value of the two child measures? For example, if you had two child measures scores of 25 and 75, instead of showing the average of 50, it would show the score as 25. Is this what you had in mind?

If so there's a way you can do this today.

  • Let's say you have your two sub measures "Call Volumes" and "User Volumes" under the Group measure "Usage". 
  • Add a third sub measure under "Usage" called "Blended Usage"
  • Set the weights for the "Call Volumes" and "User Volumes" to be zero and take the points previously assigned to them and give those points to "Blended Usage"
  • Set "Blended Usage" as an automated measure (meaning it can only be edited by the rules engine).
  • Write a simple rule that fetches the values of "Call Volumes" and "User Volumes" and performs the MIN aggregation on them in the fetch task. 
  • The Setup Action of that rule will write the MIN value from the fetch to the "Blended Usage" measure
  • Then schedule the rule you just created above to run after any rules that you use to set the values of "Call Volumes" and "User Volumes"
This will allow you to have a group score that is the MIN of your two sub measures. 

Hope this helps!