Skip to main content
darkknight
Expert ⭐️
Sep 8, 2020 4:36 PM UTC
New Idea

Absence of Scorecard Measure data

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 ⭐️
Sep 17, 2020 2:51 PM UTC

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

Translate
shantan_reddy
Gainsight Employee ⭐️
Gainsight Employee ⭐️
Sep 28, 2020 10:45 AM UTC

@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.

Translate
david_narunsky
Contributor ⭐️⭐️⭐️
Oct 29, 2020 11:00 PM UTC

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

Translate
anthonysabato
Helper ⭐️
Oct 30, 2020 1:22 PM UTC

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.

Translate