Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
How can I create the following report with these models: How would I group by date in raw Mysql or in Eloquent? For example Date(created_at) | TotalRequests (Count(id)) | TotalOrders(Count(id))
Typically it is nice to at least try something on your own first then post what you have tried and others are usually glad to help. But an example of an advanced query https://laracasts.com/discuss/channels/eloquent/orderby-computed-related-attribute
@jlrdw here is my basic attempt: http://laravel.io/bin/wJzML
Please or to participate in this conversation.