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?
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