Laravel distinct count group by

    public function showUniqueUsersBhagwatByDate(Request $request)
    {
        \LogActivity::addToLog('admin');
        $data= array();
        $data = DB::table('cal_user_activity')->select(DB::raw('DATE(updated_at) date'),DB::raw('count(DISTINCT  user_id) as page_count'))->where('module','BhagwatAudio')->groupby('date')->get();
        return view('admin/shownewbhagwatgeetalistener',['data'=>$data,'title'=>'Show Uniques Users Listeners','isOthers'=>1]);
    }


Leave a Reply