How to add a SUM row to a resource table?

Say you have a column on a resource table with prices. And you want the price total in a new row at the bottom of the table.

What would be the best way to do this?

Level 102

You can run sum on the query

MyModel::where('foo', 1)->sum('bar');

Level 102

Or if it's a relationship you mean

MyModel::where('foo', 1)->withSum('foop', 'bar')->get();

Level 3

@Sinnbeck That's on metrics, no?

I mean on the actual index table that contains the records.

Level 102

@EckyEckyPtang oh sorry I completely missed you tagged it as Nova. My bad! To my knowledge it's not build in. I think people use metrics to show such things https://nova.laravel.com/docs/4.0/metrics/defining-metrics.html#sum

Please or to participate in this conversation.