I am looking to have a heatmap developed where the size of the area will be based on a measure. The colors of the heatmap will vary with the measure I am doing the chart with. That part is working,but all areas are of same size irrespective of the volume (which is another measure)

This message has been edited. Last edited by: <Kathryn Henning>,

Tarun,

I believe you want to do a treemap.

Here is a sample code:

JOIN STCD IN GGSALES TO STORE_CODE IN GGSTORES AS J1
DEFINE FILE GGSALES
PROFIT/D12.2= DOLLARS-BUDDOLLARS ;
END
GRAPH FILE GGSALES
SUM PROFIT UNITS
BY ST
BY PRODUCT
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET LOOKGRAPH TREEMAP
ON GRAPH SET STYLE *
*GRAPH_JS
colorMode:'byInterpolation',
colorModecolors: ['teal','cyan', 'beige', 'burlywood', 'yellow', 'cream']
*END
ENDSTYLE
END

Hello

This focus code works . But I want to have this done from inside Infoassist 8.0.07. Is it possible ? If I execute this code in infoassist it results in Error.My intention is to see if my power users can choose various configurations in infoasist and be able to create this Heat map kind of Chart although not exactly like a heatmap.

Any thoughts on this.

Not available in InfoAssist, per an IBI consultant that was working with us a couple of weeks ago. I got the impression that the functionality was planned for a future release (8.1?) His recommendation was to use InfoAssist to create a Mekko or Heatmap, and then go into the code to to change the lookgraph command.

Sorry for bringing up a closed topic, but VLozovsky, your solution worked for the graph, but the color portion doesn't seem to be doing anything. I just get red boxes. What am I doing wrong?

GRAPH FILE CAR
-* Created by Info Assist for Graph
SUM CAR.BODY.SALES
BY CAR.COMP.CAR
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET LOOKGRAPH TREEMAP
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_JS
colorMode:'byInterpolation',
colorModecolors: ['teal','cyan', 'beige', 'burlywood', 'yellow', 'cream']
*END
ENDSTYLE
END

Nevermind.. For anyone else with the same question..

*GRAPH_JS
treemapProperties: {scaleCellFonts: true},
yaxis: {mode: 'color', colorScale: {colors: ['teal','cyan','burlywood','lightblue']}}
*END