PHP code snippet – 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(); }