Using Metrics with relations

+1 Did you find any solution?

Anyone sorted this. I need to do a sum on two different resources/tables.

So sum a column in one table, then use the result against another column in a different table

i end up use like so for one of my metrics. you can use eloquent. i was defining as SaleItem::class but then i changed it and now i could filter out with the way i want. you can also use with() method to eager load your relations

return $this->count($request, SaleItem::where('salable_type', Token::class)->with('salable'), 'salable_id', 'token_type')->label(function ($value) {
            return  $value . ' Token';
        });