Skip to main content
darkknight
Expert ⭐️
September 8, 2020
New Idea

Absence of Scorecard Measure data

  • September 8, 2020
  • 14 replies
  • 386 views

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.

14 replies

anthonysabato
Helper ⭐️
September 17, 2020

Yeah its a lot of work for something def that should be built in, same for running historical scores like 1.0 had.

shantan_reddy
Gainsight Employee ⭐️
Gainsight Employee ⭐️
September 28, 2020

@anthonysabato @davebrown2242 We did consider it, but as I said, there are performance concerns and did not proceed. We will get to this once the performance issue is addressed.

david_narunsky
Contributor ⭐️⭐️⭐️
October 29, 2020

@anthonysabato  You are my hero! Had to go through some iterations, but got it working beautifully. Thank you!

anthonysabato
Helper ⭐️
October 30, 2020

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.