I would like to create a heatmap Chart. By heatmap i mean a table chart where the different cells have different colors based on the values they contain
(low values - BLUE - high values RED and all shades in between).
As I am lazy i want create a script that sets the range definitions.
According to the CLI documentation, this should be easy
specifies range definitions for computed expressions included in a table chart, where value consists of the following attributes: expressionname;range field name;range label:lower limit:upper limit:icon:background color:text color:text style:display format; lower limit:upper limit:.....;extend to axis .
so I started with the command.
im editchart --rangeDefinitions="Count;myLabel:0.0:10.0::200,255,255:200,255,255:Plain:Value;false" "Heatmap"
Unfortunately this command completes without any error, but shows no result, meaning no new range in the defined Chart.