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

8 votes114 views1 answer
Laravel symlink command
PHP Laravel
1 vote102 views2 answers
Get the unique rows from table laravel
PHP Laravel
0 vote99 views1 answer
Laravel collection pop
PHP Laravel
3 votes105 views3 answers
Laravel get certain columns
PHP Laravel
0 vote107 views1 answer
Id type laravel
PHP Laravel
20 votes98 views4 answers
Laravel where is null
PHP Laravel
0 vote128 views1 answer
How to pass parameters to relationships laravel
PHP Laravel
1 vote108 views4 answers
Create json laravel
PHP Laravel
5 votes97 views2 answers
Current loggedin user laravel
PHP Laravel
0 vote101 views1 answer
Laravel make migration in subfolder
PHP Laravel