I am trying to import our values for scorecard as this is calculated outside GS. Not every measure will have a value.
The rule will error is when trying to attempt to insert when the value is null. I have created a separate rule for each measure, however my concern is that if a measure ever goes from a value to null I am not able to overwrite as the rule will not insert a null value.
Is there another way to allow null values that I am unaware of?
Hi
For your rule, you should have separate actions for each score and null value. So for example, action 1 would set the score to Green and it would be filtered for the just the green score data. And so on for Red and Amber or however many scores you have.
For nulls, you would filter for the null value and the action would be to set the score to N/A. I would recommend adding a comment to signal that it’s unfilled because there is null data.
Here is some more information on it:
Hope this helps!
Hi
We should set the Score to NA and provide the Criteria as well. Example if the some field value is Null, then set the Score to NA for the measure in the selected Scorecards.
Screenshot:
Here in my case I am seting to Score to NA to the “Cx Risk Status” measure which is existed in 2 Scorecards with the Flagged Risks = Null criteria.
Thanks.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.