Filament•14mo ago

Summarized Table Rows

Hi, I am working on a statistic for a clients project and they get a lot of bookings on different platforms. We'd like to display a summarization of the bookings grouped by platform. Like in the attached example, "Reisefux" would be the platform and all the values are aggregated by the bookings of this specific platform. There could be more platforms than 1.

Solution:

There is an feature, but it would group the bookings and show a summary below every group. If you want a custom one I think you need to overwrite the table footer

Jump to solution

7 Replies

alexanderkroneisOP•14mo ago

At this stage, we are not interested in the specific bookings, we just want a brief overview how every platform is performing.

Solution

Dennis Koch•14mo ago

There is an feature, but it would group the bookings and show a summary below every group. If you want a custom one I think you need to overwrite the table footer

alexanderkroneisOP•14mo ago

I assume you mean Summaries?

Installation - Panel Builder - Filament

Dennis Koch•14mo ago

Yes Summaries combined with Group By

Dennis Koch•14mo ago

https://filamentphp.com/docs/3.x/tables/grouping

Grouping rows - Table Builder - Filament

alexanderkroneisOP•14mo ago

groupsOnly() was all I needed 😮 I read this page 2 times 💀 Thanks! 😄

alexanderkroneisOP•14mo ago

This is not allowed?

TextColumn::make('payments_sum_amount')
    ->label(__('Umsatz'))
    ->sum('payments', 'amount')
    ->formatStateUsing(fn($state) => format_money($state, 'EUR'))
    ->toggleable()
    ->summarize(Sum::make()),

TextColumn::make('payments_sum_amount')
    ->label(__('Umsatz'))
    ->sum('payments', 'amount')
    ->formatStateUsing(fn($state) => format_money($state, 'EUR'))
    ->toggleable()
    ->summarize(Sum::make()),

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'payments_sum_amount'

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'payments_sum_amount'

Gaming

Programming

Summarized Table Rows