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 vote318 views1 answer
Session not working php
PHP
0 vote335 views1 answer
Laravel eloquent many to many query using whereHas
PHP
-1 vote303 views2 answers
Laravel latest
PHP
8 votes329 views6 answers
Laravel transaction
PHP
1 vote292 views1 answer
Debug $_POST
PHP
1 vote359 views4 answers
Brew downgrade php
PHP
0 vote360 views1 answer
Insert chevron on form select field on caldera
PHP
0 vote339 views1 answer
How to remove words in contain integer php
PHP
-1 vote315 views4 answers
Include blade file in laravel
PHP
2 votes366 views2 answers
How set variable public in static method in laravel
PHP Laravel