Can we summarize using Sushi?

Hi, can we summarize a table when using Sushi? When I add

<?php

Tables\Columns\TextColumn::make('revenue')
    ->label(__('Umsatz'))
    ->money('EUR')
    ->sortable()
    ->toggleable()
    ->summarize([
        Tables\Columns\Summarizers\Sum::make(),
    ]),

<?php

Tables\Columns\TextColumn::make('revenue')
    ->label(__('Umsatz'))
    ->money('EUR')
    ->sortable()
    ->toggleable()
    ->summarize([
        Tables\Columns\Summarizers\Sum::make(),
    ]),

I get this error: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '":memory:"."booking_statistics") as booking_statistics' at line 1

Flare

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '":memory:"."booking_statistics") as booking_statistics' at line 1 (Connection: mysql, SQL: select sum(booking_statistics.revenue) as "8U9j4PjzPdfhM8xS" fr...

2 Replies

Paulo Cavalcanti•12mo ago

Same question here

ruddy•10mo ago

Any updates on this? I'm facing the same issue, but I haven't been able to find a solution yet. If anyone has insights or a fix, I would greatly appreciate your help.

Gaming

Programming

Can we summarize using Sushi?