Charts sorting and colors

[nip1904]

How do I achieve sorting charts as defined and how set individuell color for each item.

Example:

select
    'chart'             as component,
    'bar'               as type,
    TRUE                as labels;
select
   'item1'  as label,
   10       as value;
select 
   'item2'  as label,
   20       as value;
select
   'item10' as label,
   21       as value;

As you see item10 is before item2 after rendered but after item2 (as I want) in the code.

Second Question is: I wan't all items to have different color.

Any ideas?

[lovasoa]

Hello !

We should definitely add an example for that to the documentation. Here is how you can achieve it:

select
    'chart'             as component,
    'bar'               as type,
    TRUE                as stacked;
select
   'item 01'  as series,
   'item 01'  as label,
   10       as value;
select 
   'item 02'  as series,
   'item 02'  as label,
   20       as value;
select
   'item 10' as series,
   'item 10' as label,
   21       as value;

I zero-padded item numbers in order for the alphabetic ordering to match what you would expect.

[lovasoa]

The reordering of values was introduced by mistake in a previous version, and is fixed in v0.35.2, released just now :)