/PHP/Laravel/Laravel count group by date

Laravel count group by date

    $usersData = User::select(DB::raw('DATE(created_at) as date'), DB::raw('count(*) as total'))
            ->groupBy('date')
            ->orderBy('date', 'desc')
            ->take(7)
            ->get();

Similar codes

3 votes165 views2 answers
Laravel migration on delete set null
PHP Laravel
0 vote200 views1 answer
Laravel string capitalize in view
PHP Laravel
0 vote177 views2 answers
Laravel FileManager Display Blank pop up page
PHP Laravel
8 votes176 views3 answers
Force delete soft delete laravel
PHP Laravel
0 vote173 views1 answer
Laravel check if relationship has data
PHP Laravel
0 vote191 views2 answers
How to get just the first row from a table in laravel
PHP Laravel
38 votes251 views6 answers
Laravel foreign key
PHP Laravel
0 vote174 views2 answers
Collection get first element laravel
PHP Laravel
2 votes161 views3 answers
Laravel public static variable
PHP Laravel
0 vote183 views1 answer
Laravel vendor publish all files
PHP Laravel