How to count distinct values from a collection in Laravel?

laravel eloquent

15,058

Solution 1

Update for 2021/L6+

thanks @JeremyWadhams

$degrees->groupBy('Degree')->map(fn ($people) => $people->count());
// or using HigherOrder proxy on the collection
$degrees->groupBy('Degree')->map->count();

Using collection methods this would be it:

$degrees->groupBy('Degree')->map(function ($people) {
    return $people->count();
});
// Collection {
//   'Master' => 13,
//   'Bachelor' => 9,
//   'PhD' => 3
// }

Solution 2

There is a Collection Helper called CountBy, does exactly what you need.

Collections CountBy

$degrees->countBy('Degree');

It will retourn as expected

 Array
(
    [Master] => 13
    [Bachelor] => 9
    [PhD] => 3
)

Simple :D

15,058

Pathros

I like developing web apps with Laravel, including the deployment and security setting up. My interests: Favorite programming languages/frameworks/technologies/OS Laravel Homestead Php Javascript Docker Nginx Traefik Laradock Ubuntu MySQL Livewire Alpine.js Tailwind CSS Bootstrap Git wish list: Ansible Arduino Docker swarm Envoy Flutter Kubernetes Python Terraform Oracle APEX R Nvim Raspberry pi

Updated on September 15, 2022

Comments

Pathros about 1 month

I have been struggling on how to get the quantity of distinct values from a collection in Eloquent.

I have been trying several methods, such as unique(), values(), etc., found on the docs. Even though there is indeed a count() method, there is no method to get the count of distinct values.

For example, by applying the following query

$technicalshighestdegrees = Capsule::table('academicinfo AS fa')
        ->selectRaw('DISTINCT fa.academic_id AS Id,c.name AS Degree')
        ->leftJoin('academics AS a','fa.academic_id','=','a.id')
        ->leftJoin('cat_degree AS c','fa.level','=','c.id')
        ->whereIn('a.type',['Technical'])
        ->where('a.status','!=','Retired')
        ->where('c.degree',true)
        ->orderBy('a.id')
        ->orderBy('c.hierarchy','desc')/*http://stackoverflow.com/a/17006377/1883256*/
        ->get();

I get this collection:

Since, I just want to get the highest degrees (a user Id may have several historical degrees), I apply the unique() method, that according to the docs, it leaves only the first original value, in my case, I have already ordered them by hierarchy desc:

$technicalshighestdegrees = $technicalshighestdegrees->unique('Id');

And now I get the following collection (reduced to 25 items, which is exactly the total number):

What I want is to get the quantities for each distinct degree value as follows:

Array
(
    [Master] => 13
    [Bachelor] => 9
    [PhD] => 3
)

But in an Eloquent collection...

How can I achieve this?

Jeremy Wadhams over 2 years

I love this trick, thank you! You could simplify it one step more using the higher order map, like $degrees->groupBy('Degree')->map->count()
commadelimited almost 2 years

Too bad this was posted after the original accepted answer, this would be the best way to do it.
Sagar Gautam almost 2 years

Hello sir, Is there any way to count number of these unique groups ? in your example count should be 3
Jarek Tkaczyk almost 2 years

@SagarGautam $degrees->groupBy(..)->count() will do the trick
Jarek Tkaczyk almost 2 years

@JeremyWadhams a bit late on my part, but thanks for your comment! Feel free to EDIT existing answers with such improvements - I'm sure everyone will appreciate your effort!
Sagar Gautam almost 2 years

@JarekTkaczyk count doesn;t work with group by !
Julio Popócatl over 1 year

You are falling to de DRY principle