Reporting on Activity Log data without exporting to excel

edited 12/09/19 in Smartsheet Basics

I am looking for a method to query/report on activity log data without exporting to excel and then importing back I into smartsheet.


For example: I need to expose via a Dashboard the number of times specific Dashboards and Sheets are being accessed.

Currently activity logs are exported to excel; a pivot table is created to provide summary information which is then copied back into a summary smartsheet for display on an executive summary dashboard.

Any thoughts or suggestions on how to accomplish this task without all the manual "workarounds" is greatly appreciated.