Skip to main content
jon_harris
jon_harris
Contributor ⭐️⭐️⭐️
May 25, 2018

ScoreCard 2.0 Exceptions

  • May 25, 2018
  • 7 replies
  • 164 views
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.

      7 replies

      aditya_marla
      aditya_marla
      Helper ⭐️⭐️⭐️
      May 29, 2018
      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)
        jon_harris
        jon_harrisAuthor
        Contributor ⭐️⭐️⭐️
        May 29, 2018
        Exactly right!
          mark_gecsey
          mark_gecsey
          Contributor ⭐️⭐️⭐️⭐️
          May 29, 2018
          I would second that request. We have a specific need for that as well.
          Mark Gecsey
            sai_ram
            sai_ram
            Expert ⭐️⭐️
            May 31, 2018
            Hi All, This is a valid request.We have added this to our product backlog.
              dan_ahrens
              dan_ahrens
              Expert ⭐️⭐️⭐️
              June 1, 2018
              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!
              VP of Customer Success at Forcepoint
              sai_ram
              sai_ram
              Expert ⭐️⭐️
              April 24, 2019
              @jon_harris checking to see whether the solution given by @dan_ahrens worked for you or not?

              Keep posting!

              R
              rakesh_lingala
              Helper ⭐️⭐️⭐️
              June 16, 2020

              Hello Everyone,

              Happy to announce that your request has been considered and included as part of the v6.15 release. You can now delete Opportunity Records from GS Opportunity. Admins can now add Exceptions for measure groups as well as use conditions based on measure groups when configuring exceptions for the Overall Score. This gives them more granular control over measure group scores and the Overall Score. Only the measures within a particular group can be used to create an exception for the group.

              This feature is implemented in both SFDC and NXT versions.

              Thanks for posting!

                Terms & ConditionsAccessibility statement