data = ({
series: Object.entries(rawdata[0]).map(
([key, value]) =>
({
name: key,
type: (isNaN(value) || value === null) && !key.startsWith('Years') ? "dimension" : "measure"
})
),
records: rawdata.map( record => {
if (!record['YearsCode']) record['YearsCode'] = 0;
else if (String(record['YearsCode']).startsWith('Less')) record['YearsCode'] = 0;
else if (String(record['YearsCode']).startsWith('More')) record['YearsCode'] = 50;
if (!record['YearsCodePro']) record['YearsCodePro'] = 0;
else if (String(record['YearsCodePro']).startsWith('Less')) record['YearsCodePro'] = 0;
else if (String(record['YearsCodePro']).startsWith('More')) record['YearsCodePro'] = 50;
return Object.values(record)
.map(value => (value ? value : 0))
})
})