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

9 votes364 views6 answers
Laravel 8 date format
PHP Laravel
1 vote345 views1 answer
Laravel uppercase first letter
PHP Laravel
0 vote391 views1 answer
Required_unless laravel
PHP Laravel
0 vote381 views1 answer
Laravel 8 model filter
PHP Laravel
0 vote389 views4 answers
Installing bootstrap ui in laravel app
PHP Laravel
1 vote361 views1 answer
Autoload file laravel
PHP Laravel
0 vote437 views2 answers
Declare variable in view for loop laravel
PHP Laravel
0 vote320 views1 answer
Laravel token logout
PHP Laravel
0 vote421 views1 answer
Laravel how to address to git repo for develop packages
PHP Laravel
2 votes380 views3 answers
How to get the size of an uploaded file in laravel
PHP Laravel