I am posting this on behalf of Jeffrey Kirkpatrick. Is there a flag in the Unified Scorecard Fact table that identifies scores that have gone stale?
Field in Unified Scorecard fact table to identify stale scores
+5If you want to trigger actions based off of stale scores, there is no way to do this today. We have to basically go off of timeframes. It would be helpful to have a “Stale” flag to identify when a score is stale.
I found a partial solution for this - when setting up a mass edit report on Unified Scorecard Fact, you can set a filter to show only the Stale scores for a given measure, where “stale” is defined by the validity period of the measure.
This gets you part of the way there, but there are some limitations:
- Your assertion is correct: there is no boolean “Is Stale” field on the Scorecard fact tables; to my understanding accessing this information is only possible via a Mass Edit report.
- It is not possible to select the inverse of Stale (it is not possible to exclude all stale scores from a report, only to include).
Hope this helps!
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.