Group table by year

Is it possible to group a table by 'year' from a date column?

3 Replies

jop00OP•15mo ago

I've tried ->groupQueryUsing() but doesn't change the default grouping

->groupQueryUsing(fn (Builder $query) => $query->groupBy(DB::raw("YEAR(deadline)")))

->groupQueryUsing(fn (Builder $query) => $query->groupBy(DB::raw("YEAR(deadline)")))

This doesn't change the default grouping by day Could someone test if groupQueryUsing() is actually working?

I want to group by "month-year" but can't seem to make it work either...