Breaking News: Grepper is joining You.com. Read the official announcement!

how to get yearly chart in laravel

Horrible Hamerkop answered on May 17, 2021 Popularity 4/10 Helpfulness 4/10

answer how to get yearly chart in laravel

how to get yearly chart in laravel

Comment

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

Popularity 4/10 Helpfulness 4/10 Language php

Source: stackoverflow.com

Tags: get laravel php

Link to this answer
Share Copy Link