Like most SaaS companies, the Flare back-office features a neat dashboard showing some of our key metrics. Using Laravel Nova it's pretty easy to aggregate data per model like the total number of errors or the active subscriptions per week. Behind the scenes these dashboard tiles and graphs use simple database queries. For example, the number of active subscriptions is a simple SELECT COUNT(*) query on the subscriptions table. But how do we query new subscriptions per week?
