function obtenirDadesFiltrades()
{
let year1 = interval_years[0];
let year2 = interval_years[1];
let hdiCategory = hdiCategory_filter;
let parameter = parameterToAnalize_filter;
let country = country_selected;
let filteredData = country == "" ?
co2_amb_hdi_4.filter(d => (d.year === year1 || d.year === year2) && d.hdi_category === hdiCategory) :
co2_amb_hdi_4.filter(d => (d.year === year1 || d.year === year2) && d.country === country);
let transformedData = {};
filteredData.forEach(d => {
if (!transformedData[d.country]) {
transformedData[d.country] = { value_start: null, value_end: null};
}
if (d.year === year1) {
transformedData[d.country].value_start = d[parameter];
}
else if (d.year === year2) {
transformedData[d.country].value_end = d[parameter];
}
});
if(country != "")
{
let filteredDataHDICategory = co2_amb_hdi_4.filter(d => (d.year === year1 || d.year === year2) && d.hdi_category === hdiCategory);
let valuesStart = filteredDataHDICategory.filter(d => d.year === year1).map(d => d[parameter]);
let valuesEnd = filteredDataHDICategory.filter(d => d.year === year2).map(d => d[parameter]);
let medianStart = d3.median(valuesStart);
let medianEnd = d3.median(valuesEnd);
transformedData[hdiCategory] = { value_start: medianStart, value_end: medianEnd };
let filteredDataWorld = co2_amb_hdi_4.filter(d => (d.year === year1 || d.year === year2));
let valuesStartWorld = filteredDataWorld.filter(d => d.year === year1).map(d => d[parameter]);
let valuesEndWorld = filteredDataWorld.filter(d => d.year === year2).map(d => d[parameter]);
let medianStartWorld = d3.median(valuesStartWorld);
let medianEndWorld = d3.median(valuesEndWorld);
transformedData["World"] = { value_start: medianStartWorld, value_end: medianEndWorld };
}
let resultArray = Object.keys(transformedData).map(key => ({
country: key,
...transformedData[key]
}));
return resultArray;
}