Laravel count 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 vote417 views1 answer
Touches in laravel
PHP Laravel
0 vote412 views1 answer
Flash message laravel for incorrect password
PHP Laravel
0 vote403 views1 answer
Use app http models in laravel 8
PHP Laravel
9 votes346 views4 answers
Composer require laravel/ui for laravel 6
PHP Laravel
8 votes361 views3 answers
Laravel check record exists
PHP Laravel
0 vote441 views1 answer
Update php version in laravel
PHP Laravel
13 votes336 views4 answers
Laravel migration remove column
PHP Laravel
2 votes330 views1 answer
Comments table example in laravel
PHP Laravel
0 vote371 views1 answer
Seprate day and year from laravel to timestamp
PHP Laravel
5 votes370 views3 answers
Laravel created_at where date format
PHP Laravel