Chart graphics and datasets from supabase + colors

How do i customize data inside chart using advanced mode?

return [{
label: ‘Scatter Dataset’,
data: [
{ x: 9, y: 8, r: 1},
{ x: 20, y: 20, r: 5 },
{ x: 45, y: 40, r: 3 }
]
}]

thats what i put into datasets and worked but what i want is to put the data from supabase and for every data i want a new random color

My supabase table has the columns x, y and r


Since i want to send the data to supabase using the form inputs and with this data i want to create the graphic using the inputs for x,y and r

const dataPoints = collections[‘3e9c391f-523a-4ba3-80fa-b5be2a5882e8’]?.[‘data’]?.map(item => ({
x: item[‘market’],
y: item[‘knowledge’],
z: item[‘investment’]
}));