Solved

Report: Stale Scorecard update

  • 1 February 2024
  • 1 reply
  • 30 views

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?

icon

Best answer by kstim 2 February 2024, 22:14

View original

1 reply

Userlevel 4
Badge +6

@HeatherDee Are you looking to see when 1) the scorecard itself was last modified (Administration > Scorecard > “Last Modified On”) or 2) when measures within a scorecard or the overall score haven’t been updated?

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 😄

Reply