Group Collection by month

@Sinnbeck it is 2022-07-19T21:18:38+0000, datetime like this

@Kris01 ah ok so the example is the final output? So amount is a sum of all amounts that month?

How does the input look?

@Sinnbeck The input looks like this:

array => {
	0 => {
			amount: 5000 usd
			date: 2022-07-19T21:18:38+0000
	}
	1 => {
			amount: 300 usd
			date: 2022-07-20T21:18:38+0000
	}
}

and I would like to sum up the amount and group them by month, to have a final result of: february the total amount was x usd march the toal amount was x usd

@Kris01 ok something like this

$x = collect($data)->map(function($item) {
     $item['amount'] = str_replace(' usd', '', $item['amount']) ;
     return $item;
})->groupBy(function ($item) {
    return \Carbon\Carbon::parse($item['date'])->format('Y m');
})->map->sum('amount')
->map(function ($sum, $date) {
    return [
        'month' => $date, 
        'amount' => $sum
  ];
});