How to get yearly chart in laravel

    public function getYearlyVisits()
    {
        $monthlyVisitors = DB::table('shorteners')
            ->select([
                DB::raw('YEAR(created_at) as year'),
                DB::raw('count(total_visits as total_visits'),
            ])
            ->groupBy('year')
            ->get();
    }

Source: stackoverflow.com

Similar codes

0 vote115 views3 answers
Script @php artisan package:discover handling the post-autoload-dump event returned with error code 255
PHP
0 vote128 views1 answer
Laravel group concat values showing duplicate
PHP Laravel
7 votes137 views1 answer
Ternary operator laravel blade
PHP Laravel
3 votes137 views2 answers
Laravel check if query builder is empty
PHP Laravel
0 vote132 views1 answer
Laravel model query limit
PHP Laravel
0 vote144 views1 answer
Omnipay capture
PHP
19 votes138 views6 answers
Array_search in php
PHP
8 votes108 views6 answers
Php isset
PHP
9 votes138 views4 answers
Laravel group route controller
PHP
0 vote139 views1 answer
Laravel cron job on shared hosting
PHP Laravel