How to get average of count column

@Dusted Try aliasing the column, as you’re selected it ((`count(created_a) and that’s the name it’ll use.

 $dailyAverage = \DB::table('reviews')
            ->select(\DB::raw("to_char(date_trunc('day', created_at),'YYYY-MM-DD') as date, count(created_at) as count"))
            ->whereIn('location_id', $locationIds)
            ->groupBy('date')
            ->avg('count');

@martinbean i still get the same error as before

Did anyone fix this problem. I am having the same situation and I can not figure it out :|

how about ->avg(\DB::raw('count'))?

I think Martin's answer is close, but count is MySQL keyword, so its not accepted. Lets rename it to something else.

$dailyAverage = \DB::table('reviews')
            ->select(\DB::raw("to_char(date_trunc('day', created_at),'YYYY-MM-DD') as date, count(created_at) as     
            reviews_count"))
            ->whereIn('location_id', $locationIds)
            ->groupBy('date')
            ->avg('count');

Also, counting the created_at field is weird. I assume you want to count the number of reviews. So I rewrite it like this:

$dailyAverage = \DB::table('reviews')
            ->select(\DB::raw("to_char(date_trunc('day', created_at),'YYYY-MM-DD') as date, count(id) as     
            reviews_count"))
            ->whereIn('location_id', $locationIds)
            ->groupBy('date')
            ->avg('count');

Now you can do find average and count using Eloquent, like this:

public function index()
    {
        $company = company::withAvg('rating as ratings', 'rating')
->withCount('comment as comments')
->latest()->filter()->paginate(12);
  
        return view('Company.Record.index', compact('company'));
    }