Need to show sum of a column (amount) from a table (transactions) except count

[shovann-notebrains]

For my TransactionResource except row count I want to show sum of collected amount.

Is this feature can be done in this plugin ?

public static function getOverlookWidgetQuery(Builder $query): Builder
{
return $query->where('host_id', '=', auth()->user()->id)->sum('amount');
}

[awcodes]

This isn't currently possible, sorry. The query is counting the number of records so a sum won't work.

[shovann-notebrains]

Thanks for your reply.
Can we get this update into the next version?

[awcodes]

I won't rule it out, but it's not really the point of the plugin. But sounds more like a custom widget use case.

[shovann-notebrains]

Ok, thank you