Using Scheduled Reports to Populate Daily Summary Tables


I wanna build a series of summary tables that each day is populated with a summary of yesterdays transactions etc.

Can this be done in Mode with Scheduled Reports or what are the best practices?

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Emil ! I'm surprised no one from Mode has responded to you about this yet. I have several reports that show summaries for yesterday, the past week, etc. and yep, I use Scheduled Reports to make this happen, along with inserting a fixed date range in my WHERE statement, something like: 

    WHERE created_at > today() - interval 1 day)

    Works very well for me. 

    Reply Like
  • Hey Emil , sorry for the delayed response! Adam Stone 's solution is probably the best way to accomplish this - thanks for that Adam!

    Let me know if you have any questions about implementing this!

    Reply Like
Like1 Follow
  • Status Answered
  • 1 yr agoLast active
  • 2Replies
  • 599Views
  • 3 Following