Aggregate dashboard report data by time interval

This is great @simon thanks.
Forgive me for simplistic question, but is it possible to:

  1. Include custom written reports in Dashboard, Reports section and how?
  2. Trigger some action based on the result of a query run in DataExplorer - for example send a message to admins?

Thanks