/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 vote291 views1 answer
Users not having any role laravel spatie
PHP Laravel
0 vote197 views1 answer
Laravel dingo api response
PHP Laravel
0 vote197 views1 answer
Laravel save or post
PHP Laravel
1 vote242 views1 answer
Laravel eloquent get only field name
PHP Laravel
0 vote176 views1 answer
Laravel withcount change name
PHP Laravel
0 vote194 views1 answer
Ignore user id on email validation laravel
PHP Laravel
0 vote193 views1 answer
Laravel Deployment to google cloud app engine flexible environment app.yaml file
PHP Laravel
22 votes193 views6 answers
Where like in laravel
PHP Laravel
0 vote203 views1 answer
Store image to s3 laravel
PHP Laravel
0 vote178 views1 answer
Spatie/laravel-activitylog display only changed data
PHP Laravel