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();
}