Laravel Trend query example

 $data1 = Trend::query(Payment::where('team_id', Filament::getTenant()->id)
        ->where('status', 'completed')->whereYear('payment_date', $activeFilter))
        ->between(
            start: Carbon::parse("$activeFilter-01-01"),
            end: Carbon::parse("$activeFilter-12-31") ,
        )
        ->dateColumn('payment_date')
        ->perMonth()
        ->sum('total');