Skip to main content
M
mrump16-Pearl
16-Pearl
April 5, 2016
Solved

create/edit chart via CLI

  • April 5, 2016
  • 1 reply
  • 1338 views

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?

    Best answer by mrump

    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)

    1 reply

    M
    mrump16-PearlAuthorAnswer
    16-Pearl
    April 5, 2016

    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)

    Terms & ConditionsCookie settingsAccessibility statement