Report last modified date on Scorecard
Userlevel 2
Is there a good way to report on the last modified date of a scorecards comments? We would like to pull a list of scores that might be stale and need to be updated.
Userlevel 6
+5
Yes, we created one a few weeks ago, but it is specific to one metric in the scorecard that our CSMs are supposed to update weekly. We did find out that if the score, in our case is Red, Yellow, Green, or if the comment is updated, it is marked as modified.
Our report looks like this:
Scorecard Fact
Show me: Count Account Names
Group by: CSM Name
Filters:
Metric Id Name (this is the specific metric we look at)
Last Modified Date <= last 7 days.
CSM name != null
Our report looks like this:
Scorecard Fact
Show me: Count Account Names
Group by: CSM Name
Filters:
Metric Id Name (this is the specific metric we look at)
Last Modified Date <= last 7 days.
CSM name != null
Userlevel 6
There are two fields you'd want to include on this report to look at modified dates:
Last Modified Date is the overall record (will update if either score or comment is updated).
Score Last Modified Date will look at only the last time the score was updated and ignore comment updates.
Last Modified Date is the overall record (will update if either score or comment is updated).
Score Last Modified Date will look at only the last time the score was updated and ignore comment updates.
Userlevel 1
Hi Lane,
Quick question about this - does your report 'call out' which was updated? Either the score or comment? Or, does it not provide that detail?
thanks!
Quick question about this - does your report 'call out' which was updated? Either the score or comment? Or, does it not provide that detail?
thanks!
Userlevel 6
+5
Hi Anne, I'm not sure we can determine that from the rules engine. If either are updated, it shows updated.
Reply
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.
Login to the community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.