Skip to main content
Do we have an option for Dashboard to check for the reports which have not been refreshed for the past year.As we have an option reports as “Last Run date”.

 

Any help very much appreciated.
1 answer
  1. Jan 8, 2016, 8:02 AM
    To locate reports and/or dashboards deemed inactive, create a custom report type with the following:

     

    1.  Navigate to setup > create > report types.  Create a report type with Reports as the primary object and dashboard components as the child object.  Name it "Reports WITH OR WITHOUT Dashboards".

     

    2.  Create a new report using this new report type.  Include the "Last Run" field.  Run this report.

     

    3.  Then sort on the dashboard name (Title) column to separate the reports not attached to dashboards.  Finally, observe the last run date of the reports. If the dashboard's reports do not show a current last run date, then you can assume this dashboard has not been "refreshed".  Refresh triggers the report's "last run".
0/9000