/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

0 vote182 views4 answers
Installing bootstrap on laravel8
PHP Laravel
0 vote168 views2 answers
Laravel filesystem
PHP Laravel
1 vote192 views1 answer
Laravel api form request validation 404
PHP Laravel
3 votes162 views2 answers
Current user laravel
PHP Laravel
0 vote177 views1 answer
Can i do a relation between 2 coulnm in mongodb laravel
PHP Laravel
2 votes167 views2 answers
Phpmailer with laravel
PHP Laravel
0 vote168 views1 answer
Laravel property
PHP Laravel
1 vote170 views1 answer
Increament single column laravel current value + 1
PHP Laravel
14 votes174 views6 answers
Laravel debug
PHP Laravel
0 vote191 views2 answers
Save big data with laravel
PHP Laravel