More options for customising Donut and Pie Charts

[mikesealey]

Describe the feature request
Currently, the only customisation available for colours on pie charts and donut charts is to choose 5 colours that will be assigned in a repeating pattern across all segments of the chart.

Consider adding a setting to allow a column in the table to be selected for the colour, assigning a colour for that specific row.

Please also consider adding a code-option to allow a user to set a colour based on specific values from the data provider

if ($("New Data Provider.Rows.number") > 50){
  return "red"
} else if ($("New Data Provider.Rows.number") > 25)) {
  return "orange"
} else {
  return "green"
}

or

if ($("New Data Provider.Rows.task") === "unassigned"){
  return "grey"
}

This feature request is a result of discussion 13534

[linear]

BUDI-8196 More options for customising Donut and Pie Charts