Current Behaviour
Enable 'Less is More' function when setting a score
We are looking to set the score based on the average length of open projects. The rule set-up is looking at all open projects and averaging the # of days open. We would like to set the score based on the average number of days open. However, this currently sets the score to 'green' the higher the number. We would like the score to be 'red' the higher the number.
+2Thanks for sharing, Samantha. Just to confirm: Is this regarding the option where we assign scores directly based on a numeric field (avg. of case age in this case), with a flag to scale the values to fall between 0 and 100? If yes, makes a lot of sense to have an inverse scoring option available there. The only way to do this today would be to score based on thresholds (If age < x, assign green), but what you proposed is a much cleaner solution.
+2Requires an extra rule and a new field, but here's a work-around you could consider in the meantime:
- Use this rule that you have built (to calculate AVG values for each Account) to write the calculations into the CustomerInfo object.
- Now create a formula field to invert these AVG calculations (1/x; either ensure enough decimal places or do like 1000000/x).
- Now build a rule using this formula field and do the scaling between 0 and 100 like before.
+1Thanks for the suggestion! We will look into that but would love to see a simple 'inverse' checkbox.
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.