How to summarize the attributes from model?

[NaungYeHtet]

Package

Panel builder

Package Version

v3

How can we help you?

Tables\Columns\TextColumn::make('price')
    ->summarize([
        Tables\Columns\Summarizers\Sum::make(),
    ]),

protected function price(): Attribute
    {
        return Attribute::make(
            get: function (mixed $value, array $attributes) {
                return 100 * 344;
            },
        );
    }

Got sql error unknown column price

[leandrocfe]

Summarize will use the db, not attributes. If you need to calculate the price, you can use a virtual column as a table column, like this:

//migration..
$table->float('price')->virtualAs('column_a * column_b');

[StarterES-sgaleano]

Haya, did you found any workaround for this? Im facing the same issue and I cant find any answer out there.

Thanks in advance.

[luoyou]

I found a solution.

use Filament\Tables\Columns\Summarizers\Summarizer;

TextColumn::make('mobile_price')
    ->formatStateUsing(fn (string $state) => $this->priceByAgent($price, $state))
    ->summarize(Summarizer::make()
        ->label('')
        ->using(fn (Table $table) => $this->priceByAgent($price, $this->mergePrice($table->getRecords()))))

[akki-io]

You can do

use Filament\Tables\Columns\Summarizers\Summarizer;
use Filament\Tables\Table;

Tables\Columns\TextColumn::make('price')
    ->summarize(Summarizer::make()            
        ->using(function (Table $table) {
            return $table->getRecords()->sum('price');                
        })            
    ),

[StarterES-sgaleano]

Thanks you all, i have done that, the thing is that when you group records, the summary for the group will show the total sum instead of that of the group.

[long-blade]

yes but this i think is not working for summary of all pages! the all pages and the this page have always the same summarize!

[DL-Works]

public function getGivenFeesAmountAttribute()
{
    return $this->payments
        ->sum('amount');
}

want to use this attribute column for summary. Has anybody found a workaround?