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 vote250 views1 answer
Php date format minus 1 day
PHP
1 vote288 views1 answer
Laravel multiple group by
PHP Laravel
2 votes214 views1 answer
Laravel delete confirm link
PHP
1 vote229 views1 answer
Why laravel site loading only
PHP
0 vote270 views1 answer
Laravel controller constructor auth user null
PHP Laravel
11 votes243 views3 answers
Laravel get last month records
PHP
0 vote238 views2 answers
Dynamic Carousel in Laravel not working displays only one image
PHP
5 votes231 views2 answers
Throwexception laravel
PHP
0 vote247 views1 answer
Php concat variable and string
PHP
0 vote301 views1 answer
Laravel Excel numbers formatted as text still appearing as number
PHP Laravel