/PHP/Laravel/How to get yearly chart in laravel

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

10 votes188 views3 answers
Session flush laravel
PHP Laravel
2 votes219 views1 answer
Laravel's collection pagination
PHP Laravel
0 vote208 views1 answer
Sort by number of views descending laravel
PHP Laravel
3 votes213 views2 answers
Custom 404 page in laravel
PHP Laravel
34 votes214 views4 answers
Make:controller in laravel 8
PHP Laravel
1 vote209 views2 answers
Laravel cronjob
PHP Laravel
6 votes205 views3 answers
Laravel blade route redirect back
PHP Laravel
4 votes183 views5 answers
Laravel storage folder permissions
PHP Laravel
6 votes202 views2 answers
Laravel check if request has value
PHP Laravel
1 vote212 views1 answer
Laravel controller return message
PHP Laravel