F
Filament•2mo ago
phphelloworld

Summarising groups of rows - distinguish group and overall summaries

What I am trying to do: I have grouping data in a table by description. Each group shows a correct summary applying the limit check (min($totalPoints , $maxPoints)) But the overall total at the bottom incorrectly applies this same limit to the sum of all groups, rather than simply adding up the already limited group totals. How to distinguish between group and overall summaries? What I did: 
public function table(Table $table): Table
{
return $table
->defaultGroup('descr')
->columns([
  TextColumn::make('punti')
    ->summarize(Summarizer::make()
        ->label('Total Points')
        ->using(function ($query) {
            $totalPoints = $query->sum('punti'); // Sum of all points
            $maxPoints = $query->value('punti_max'); // Fetches a single value of punti_max (since it is the same for all records in the same group)                            
            return $maxPoints !== null ? min($totalPoints, $maxPoints) : $totalPoints;
        }))
public function table(Table $table): Table
{
return $table
->defaultGroup('descr')
->columns([
  TextColumn::make('punti')
    ->summarize(Summarizer::make()
        ->label('Total Points')
        ->using(function ($query) {
            $totalPoints = $query->sum('punti'); // Sum of all points
            $maxPoints = $query->value('punti_max'); // Fetches a single value of punti_max (since it is the same for all records in the same group)                            
            return $maxPoints !== null ? min($totalPoints, $maxPoints) : $totalPoints;
        }))
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?