/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

1 vote178 views1 answer
Create resources laravel
PHP Laravel
3 votes294 views2 answers
Get image width and height in laravel
PHP Laravel
2 votes228 views2 answers
Laravel has table
PHP Laravel
9 votes234 views1 answer
Npm run dev error laravel 8
PHP Laravel
0 vote225 views2 answers
Laravel store file
PHP Laravel
0 vote232 views1 answer
Laravel command Retrieve a specific option
PHP Laravel
2 votes234 views2 answers
Laravel throw exception with status code
PHP Laravel
0 vote216 views1 answer
Standalone laravel orm
PHP Laravel
4 votes214 views5 answers
Add csrf token laravel
PHP Laravel
5 votes214 views3 answers
Laravel permission denied storage log
PHP Laravel