groupedData = data
.reduce((acc, item) => {
const location = updatedLocations.find(
(loc) => item.location[0] === loc.id
);
const label = location ? location.name : "Unknown";
const existingGroup = acc.find((group) => group.location === label);
if (!existingGroup) {
acc.push({
location: label,
values: [item],
lat: location?.coordinates?.Latitude,
lon: location?.coordinates?.Longitude
});
} else {
existingGroup.values.push(item);
}
return acc;
}, [])
.filter((d) => d.lat != undefined)