When manual measures exist on Scorecard, that have never had a value loaded to that measure, there is no record in the Unified Scorecard Fact table.
This can be problematic when trying to determine how many accounts do not have a score yet. For example, our CS Perspective measure which is a manual subjective score. To report on accounts that do not have an entry in that score, we have to create a Data Designer set to include all the NA records alongside the records with a value.
Would be helpful if Unified Scorecard Fact table contained an NA record when there has never been a value entered.
I thought I was crazy that I couldn’t report on missing CSM Sentiment measure Updates. I too went the Data Designer route as well. Nulls/NAs should be respected in data. Great mention.
Regards,
Shantan
Hi.
Are you looking this in SFDC or NXT Instance. Because in NXT, I can see the record for the Manual and Automated measure even “No Value” populated in that measure.
Screenshots for the same:
Which is a manual measure with no value populated. But we can see the record in Unified Scorecard Fact Object.
Screenshot:
Correct me if my understanding is not the correct one that you people are looking for.
Thanks.
Regards,
Shantan
“Man did not get to walk on the moon easily, but that is why we make the medium dollars!”
Thanks for the insight. Hope there is a way to populate nulls/anything in place of nothing to avoid us having to maintain our custom workarounds.
All the best,
DB
We’ll try to figure out a workaround for the performance issue.
Regards,
Shantan
Ok. I didn’t test in that scenario. Got it thanks@shantan_reddy for the confirmation.
Not sure if anyone else has tried this but...I have been testing a rule to set a score to NA for those accounts with missing scores so they have a record in Unified Scorecard Fact. It does work.
Rule Set with 3 Tasks:
Rule Action:
Tip:
Testing:
I can dig it though. Seems like the default Gainsight behavior should be close to what you are doing manually. :)
DB
Yeah its a lot of work for something def that should be built in, same for running historical scores like 1.0 had.
You are so welcome@david_narunsky ! Side note, I also use this same rule to identify scores that are outdated and need to be reset instead of doing this extra lifting in individual scorecard rules. It my one “housekeeping” score rule if you will.