/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 vote168 views1 answer
Laravel Google Line Chart
PHP Laravel
1 vote189 views2 answers
Explode function in laravel
PHP Laravel
0 vote178 views2 answers
How to separate date and time in laravel
PHP Laravel
0 vote200 views1 answer
Artisan laravel require bootstrap
PHP Laravel
0 vote178 views1 answer
How to index column in laravel
PHP Laravel
0 vote181 views1 answer
Include navbar or part in layout in laravel blade template
PHP Laravel
44 votes217 views6 answers
Call seeder laravel
PHP Laravel
12 votes246 views3 answers
Displaying errors in laravel
PHP Laravel
0 vote174 views2 answers
Laravel composite unique key
PHP Laravel
-1 vote165 views4 answers
Include blade file in laravel
PHP Laravel