$item) { $data[$index]['TimeStamp'] = gmdate('d F l', $item['TimeStamp']); $readings[$data[$index]['TimeStamp']][] = $data[$index]; } $gasAverage = array('Co' => 0, 'No' => 0, 'So' => 0); foreach($readings as $key => $item) { foreach($readings[$key] as $index => $values) { $gasAverage['Co'] += $readings[$key][$index]['Co']; $gasAverage['No'] += $readings[$key][$index]['No']; $gasAverage['So'] += $readings[$key][$index]['So']; if($index === count($readings[$key]) - 1) { $gasAverage['Co'] /= $index + 1; $gasAverage['No'] /= $index + 1; $gasAverage['So'] /= $index + 1; } } $readings[$key] = $gasAverage; } $data = json_encode($readings); $response = new Response($data); $response->headers->set('Content-Type', 'application/json'); return $response; } }