/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

0 vote218 views1 answer
Check laravel first null
PHP Laravel
1 vote206 views1 answer
Db raw update laravel
PHP Laravel
8 votes204 views3 answers
Laravel change column
PHP Laravel
2 votes231 views1 answer
Laravel crud generator
PHP Laravel
0 vote188 views2 answers
Laravel logout all users
PHP Laravel
0 vote222 views1 answer
Laravel eloquent many to many query using whereHas
PHP Laravel
30 votes209 views6 answers
Laravel migration column types
PHP Laravel
0 vote210 views1 answer
Laravel list get x amount in a collection
PHP Laravel
0 vote210 views1 answer
Group by not working - Laravel
PHP Laravel
2 votes202 views2 answers
Laravel 8 websockets
PHP Laravel