Support for per-bar colors in bar charts

[wissyfaty]

Hello,

I would like to assign a different color to each bar in a horizontal bar chart, but it seems the color parameter is
only available at the top-level (component) level and not at the row level.

Here is what I'm trying to achieve:

  SELECT
      'chart'                          AS component,
      'Comptes expirant prochainement' AS title,
      'bar'                            AS type,
      TRUE                             AS horizontal,
      TRUE                             AS labels;

  SELECT '30 jours' AS label,
      100           AS value,
      'green'       AS color;

  SELECT '60 jours' AS label,
      200           AS value,
      'orange'      AS color;

  SELECT '90 jours' AS label,
      300           AS value,
      'red'         AS color;

I would expect each bar to have its own color (green, orange, red), but currently only the top-level color parameter
is applied uniformly to all bars.

Is there a way to set a different color per row in a single-series bar chart? If not, would it be possible to add
color as a row-level parameter?

Thank you!

[lovasoa]

Indeed, I understand this is a bit counterintuitive, but colors need to be declared at the top level.
Colors are attributed per-series, so you need to give a single x value to all bars, with different series:

  SELECT
      'chart' AS component,
      'Comptes expirant prochainement' AS title,
      'bar' AS type,
      TRUE  AS horizontal,
      TRUE  AS labels,
      json('["green", "orange", "red"]') AS color;

  SELECT '30 jours' AS series, 'Comptes' as label,
      100 AS value;

  SELECT '60 jours' AS series, 'Comptes' as label,
      200 AS value;

  SELECT '90 jours' AS series, 'Comptes' as label,
      300 AS value;