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 vote185 views1 answer
Yajra laravel datatables rawcolumn
PHP
0 vote191 views1 answer
Php array splice insert array in array
PHP
0 vote194 views1 answer
Laravel - Add conditional where clause in query
PHP Laravel
10 votes219 views2 answers
Convert collection to array laravel
PHP Laravel
0 vote185 views2 answers
How to connect to a mysql database using php
PHP
4 votes187 views1 answer
Uuid package generator laravel
PHP
0 vote178 views1 answer
Html windows logo
PHP
2 votes171 views1 answer
Hmtl dellete tag php
PHP
1 vote186 views1 answer
Laravel where multiple conditions on single colmn
PHP
3 votes328 views2 answers
Drupal show php errors
PHP