I’m trying to build a report that shows the # of scorecards that have not been updated within 30 days to be added to a dashboard. The Dashboard will have a global filter to filter down by user. Is there a way to accomplish this?
Solved
Report: Stale Scorecard update
Best answer by kstim
If option 1: You can use the Scorecard Master object and pull in the below fields, doing a distinct count of the scorecard name grouped by the Modified Date with a filter for Modified Date < Last 30 Days:
- Name (the scorecard name)
- Modified Date (the last modified date as shown in the Admin > Scorecard page)
If option 2: You can use your Scorecard Fact object(s), filtering to your desired measure(s) and/or scorecard name(s) and filter on the “Score Modified At” field, using Score Modified At < Last 30 Days.
Hope this helps 😄
+6If option 1: You can use the Scorecard Master object and pull in the below fields, doing a distinct count of the scorecard name grouped by the Modified Date with a filter for Modified Date < Last 30 Days:
- Name (the scorecard name)
- Modified Date (the last modified date as shown in the Admin > Scorecard page)
If option 2: You can use your Scorecard Fact object(s), filtering to your desired measure(s) and/or scorecard name(s) and filter on the “Score Modified At” field, using Score Modified At < Last 30 Days.
Hope this helps 😄
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.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.