Hi Moaaz Faracheh, great trick! Thanks!

For my use case, I expanded your code to accept some parameters like format (money) and currency, as well as the case where the table does not have a checkbox column.

See:

 
protected function getTableContentFooter(): View
    {
        return view('tables.footer', [
            'calc_columns' => [
                [
                    'column' => 'monthly_fee_in_cents',
                    'operation' => 'sum',
                    'format'=> 'money',
                    'currency' => 'USD',
                ],
            ],
            'hasCheckboxColumn' => false
        ]);
    }

 
@php use Filament\Tables\Table; @endphp
 
<x-tables::row>
    @if($hasCheckboxColumn)
    <x-tables::cell>
        {{-- for the checkbox column --}}
    </x-tables::cell>
    @endif
 
    @foreach ($columns as $column)
        <x-tables::cell
            wire:loading.remove.delay
            wire:target="{{ implode(',', Table::LOADING_TARGETS) }}"
        >
            @for ($i = 0; $i < count($calc_columns); $i++ )
                @if ($column->getName() == $column = $calc_columns[$i]['column'])
                    @php
                        $operation = $calc_columns[$i]['operation'];
                        $money = $calc_columns[$i]['format'] ?? false;
                        $currency = $calc_columns[$i]['currency'] ?? 'USD';
                    @endphp
 
                    <div class="filament-tables-column-wrapper">
                        <div class="filament-tables-text-column px-4 py-2 flex w-full {{$money ? 'justify-end text-end' : 'justify-start text-start'}}">
                            <div class="inline-flex items-center space-x-1 rtl:space-x-reverse">
                                <span class="font-bold">
 
                                    @if($money)
                                        {{ money($records->$operation($column), $currency)->format() }}
                                        @else
                                        {{ $records->$operation($column) }}
                                    @endif
                                </span>
                            </div>
                        </div>
                    </div>
                @endif
            @endfor
        </x-tables::cell>
    @endforeach
</x-tables::row>

Martin Mildner Thanks alot, I will correct it.

Sergio Jardim Thats really great thanks alot for the contribute.

Hay moaaz faracheh Can we use that similar method to count peak values of widget charts ? Because I tried doing that it gives me an error.Ty

Hello Diksha, you cannot use this exact code for the widgets i will comment below how I can apporach such thing.

This how approched it,

@php
$hasBulkAction = [false];
@endphp
@foreach($this->getCachedTableBulkActions() as $index => $action)
 
    @php $hasBulkAction[] = $action->isAuthorized(); @endphp
@endforeach
 
<x-tables::row>
 
    @if( in_array(true, $hasBulkAction) )
            <x-tables::cell>
 
            </x-tables::cell>
    @endif
 
 
 
    @foreach ($columns as $column)
        <x-tables::cell
            wire:loading.remove.delay
            wire:target="{{ implode(',', \Filament\Tables\Table::LOADING_TARGETS) }}"
        >
            @for ($i = 0; $i < sizeof($calc_columns); $i++ )
 
 
                @if ($column->getName() === $calc_columns[$i])
 
                    <div class="filament-tables-column-wrapper px-2">
                        <div class="filament-tables-text-column px-4 py-2 flex w-full justify-start text-start">
                            <div class="inline-flex items-center space-x-1 rtl:space-x-reverse">
                                <span class="font-medium">
                                    {{ money($records->sum($calc_columns[$i]), convert:  true) }}
                                </span>
                            </div>
                        </div>
                    </div>
                @endif
            @endfor
        </x-tables::cell>
    @endforeach
</x-tables::row>

@Diksha

@moaazfaracheh - Thank-you so much but just wanna know one more thing, Can I do this using map function ? I want to calculate Total number or sum of Peaks using line graph chart. Right now I setup the data array and Declare number of peaks variable and set it to zero & Loop through each element of the data array and add the value to the total and then I set the message property & Return the data for the chart . But using this in return datasets' => [ [ 'label' => 'Test Data By Month', 'data' => $data, ], ], 'labels' => ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'], ]; CAN I DO THE ABOVE WITH THIS DATASET? -> 'datasets' => [ [ 'label' => 'Prospects', 'data' => $data->map(fn (TrendValue $value) => $value->aggregate), ], ], 'labels' => $data->map(fn (TrendValue $value) => $value->date), ];

most welcome, one thing I am not getting where are you trying to get the $data from ? is it just one table in the database?

yes @moaazfaracheh

public $message = '';

protected function getData(): array
{
    // Set up the data array
    $data = [0, 10, 5, 2, 21, 32, 45, 74, 65, 45, 77, 89];
 
    // Declare number of peaks variable and set it to zero
    $numPeaks = 0;
 
    // Loop through each element of the data array and add the value to the total
    foreach ($data as $peak) {
        $numPeaks = $numPeaks + $peak;
    }
 
    // Set the message property
    $this->message = "Total number of peaks: $numPeaks";
 
 
 
    // Return the data for the chart
    return [
        'datasets' => [
            [
                'label' => 'Test Data By Month',
                'data' => $data,
            ],
        ],
        'labels' => ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'],
    ];
}

} This is the code I used.

@moaazfaracheh But I want It to be done using this return [ 'datasets' => [ [ 'label' => 'Prospects', 'data' => $data->map(fn (TrendValue $value) => $value->aggregate), ], ], 'labels' => $data->map(fn (TrendValue $value) => $value->date), ]; }

Hi again Diksha I hope this code is your approach (make sure to install the flowframe/laravel-trend package)

change the Order::class to the model you wish to use. the total_price is the column name i want to get the sum for. in the Order::class i have created_at column also which is used here to give the correct data.

<?php
 
namespace App\Filament\Widgets;
 
use App\Models\Shop\Order;
use Filament\Widgets\LineChartWidget;
use Flowframe\Trend\Trend;
use Flowframe\Trend\TrendValue;
 
class OrdersChart extends LineChartWidget
{
    protected static ?string $heading = 'Orders per month';
 
    protected static ?int $sort = 1;
 
    public string $myHeading = 'Orders per month';
 
    protected function getHeading(): ?string
    {
        return $this->myHeading;
    }
 
    protected function getData(): array
    {
        $data = Trend::model(Order::class)
            ->between(
                start: now()->startOfYear(),
                end: now(),
            )
            ->perMonth()
            ->sum('total_price');
 
        $datasets =
        [
            'datasets' => [
                [
                    'label' => 'Orders',
                    'data' => $data->map(fn (TrendValue $value) => $value->aggregate),
                ],
            ],
            'labels' => $data->map(fn (TrendValue $value) => $value->date),
        ];
 
        $sum = $data->map(fn (TrendValue $value) => $value->aggregate)->sum();
        $this->myHeading = 'Orders per month (Sum: ' . $sum . ')';
 
        return $datasets;
    }
 
}

documentation.

https://filamentphp.com/docs/2.x/admin/dashboard/charts#generating-chart-data-from-an-eloquent-model

@moaazfaracheh than-you so much :)

Hello Garadiit, the trick is for using aggregate in the footer. but you can check my last comment where it has code, it's for widgets. let me know if it help.

I've modified the code a little. Now it counts all records without depending on the page.

private array $calcColumns = [
     'visits',
     'users',
 ];
 
         protected function getTableContentFooter(): ?View
 {
     $query = $this->getFilteredTableQuery();
     $sql = [];
     foreach ($this->calcColumns as $column) {
         $sql[] = 'SUM("' . $column . '") as ' . $column;
     }
     $query->select(DB::raw(implode(', ', $sql)));
     $total = $query->get()->toArray()[0] ?? [];
 
     return view('filament.tables.table-summary', ['calcColumns' => $this->calcColumns, 'modelTotal' => $total]);
 }

And view

 
<x-tables::row>
    <x-tables::cell>
        {{-- for the checkbox column --}}
    </x-tables::cell>
 
    @foreach ($columns as $column)
        <x-tables::cell
            wire:loading.remove.delay
            wire:target="{{ implode(',', \Filament\Tables\Table::LOADING_TARGETS) }}"
        >
            @for ($i = 0; $i < count($calcColumns); $i++ )
                @if ($column->getName() == $calcColumns[$i])
                    <div class="filament-tables-column-wrapper">
                        <div class="filament-tables-text-column px-4 py-2 flex w-full justify-start text-start">
                            <div class="inline-flex items-center space-x-1 rtl:space-x-reverse">
                                <span class="font-medium">
                                    {{ $modelTotal[$column->getName()] ?? 0 }}
                                </span>
                            </div>
                        </div>
                    </div>
                @endif
            @endfor
        </x-tables::cell>
    @endforeach
</x-tables::row>