/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

12 votes123 views4 answers
Count in laravel'
PHP Laravel
0 vote141 views1 answer
Group where conditions in laravel
PHP Laravel
6 votes117 views6 answers
Laravel get current route url
PHP Laravel
10 votes114 views4 answers
Laravel migration set default value
PHP Laravel
0 vote130 views1 answer
Laravel route not calling function of controller
PHP Laravel
1 vote145 views1 answer
Laravel migration add datetime column with default
PHP Laravel
2 votes137 views1 answer
Laravel project editor
PHP Laravel
1 vote134 views1 answer
Use app name in laravel blade
PHP Laravel
1 vote139 views5 answers
Laravel jobs tutorial
PHP Laravel
25 votes141 views6 answers
Laravel carbon date format
PHP Laravel