Hello - I am trying to make a quadrant report with the quadrants based on median instead of mean. Can someone please let me know the best way to do this? I made a formula that gives me “High Profit, Low Volume” etc back based on the median. In the chart config if there a way in a scatter plot to say if Quadrant field = High Profit, Low Volume make it Green?
I tried using formatters but this just gives me median based only on x and i am not sure what to use to make it off both x and y.
{
series: [{
formatters: [{
select: ‘value < median’,
style: {
color: ‘orange’
}
}]
}]
}
Hopefully this makes sense, thank you for any help!