Skip to main content
mrump16-Pearl
16-Pearl
Apr 5, 2016 11:25 AM UTC
Solved

create/edit chart via CLI

Hi all,

I'm a bit stuck, so maybe somebody can help me.

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

--rangeDefinitions=value

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.

Any ideas?

    mrumpAnswer
    16-Pearl
    Apr 5, 2016 12:20 PM UTC

    Found it

    im editchart --rangeDefinitions="CountPro;;:0:10.::25,25,255,255:25,25,255,255:plain:value;false" "Heatmap"

    1. "Plain" (text style) and "Value" (display format) must be set to lowercase.

    2. Colors must have an Alpha value (RGBA)

    3. the  expressionname must not me named "Count" (although ic can use the Count computation)

    View in thread

    1 reply

    mrump16-PearlAuthorAnswer
    16-Pearl
    Apr 5, 2016 12:20 PM UTC

    Found it

    im editchart --rangeDefinitions="CountPro;;:0:10.::25,25,255,255:25,25,255,255:plain:value;false" "Heatmap"

    1. "Plain" (text style) and "Value" (display format) must be set to lowercase.

    2. Colors must have an Alpha value (RGBA)

    3. the  expressionname must not me named "Count" (although ic can use the Count computation)

    Translate
    Terms & ConditionsAccessibility statement