Folks,

Is it possible to create Heatmaps using WebFOCUS? In webFOCUS 8 Active Charts, I do see options for converting my current chart into a Heatmap..

But is it possible to create a Heatmap directly using WebFOCUS Infoassist chart assistant? I looked at each on of the chart type including advanced. I am not seeing anything.. Any ideas ?

Thanks, Ram.

This message has been edited. Last edited by: Ramkumar - Webfous,

quote:

Is it possible to create Heatmaps using WebFOCUS?

APP PREPENDPATH IBISAMP
-*
ENGINE INT CACHE SET ON
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
DEFINE FILE GGSALES

NEW_STATE/A2 = IF (PRODUCT EQ 'Capuccino' OR 'Mug') AND ST EQ 'CA' THEN 'OR' ELSE ST;

NEW_DOLLARS/I9C = IF ST EQ 'TN' THEN DOLLARS * .25 ELSE
                   IF ST EQ 'GA' THEN DOLLARS * .15 ELSE
                    IF ST EQ 'CT' THEN DOLLARS * 1.15 ELSE
                     IF ST EQ 'FL' THEN DOLLARS * 1.55 ELSE
                      IF ST EQ 'TX' THEN DOLLARS * 1.75 ELSE
                       IF ST EQ 'MA' THEN DOLLARS * .10 ELSE
                        IF ST EQ 'IL' THEN DOLLARS * .80 ELSE
		       IF ST EQ 'MO' THEN DOLLARS * 1.1 ELSE
                          DOLLARS;
END
-*
GRAPH FILE GGSALES
SUM NEW_DOLLARS AS 'Dollars'
    NEW_DOLLARS AS 'Dollars'
-*
BY REGION
BY NEW_STATE
-*
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH TREEMAP
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setTitleString("Retail Sales Heatmap");
setSubtitleString("By State Within Region");
setLegendPosition(1);
setFontName(getTitle(),"Arial");
setFontSize(getTitle(),48);
setFontSize(getSubtitle(),36);
*END
*GRAPH_JS
treemapProperties:{
    scaleCellFonts:true
},
"introAnimation": {
"enabled": true,
"duration": 1000
},
"heatmapProperties": {"dataColors": [
  "#D7191C",
  "#FDAE61",
  "#FFFFBF",
  "#A6D96A",
  "#1A9641"
]},
*END
ENDSTYLE
END  

New manual 'Creating HTML5 Charts With WebFOCUS Language v8.0.07' describes the relevant commands: '...ON GRAPH PCHOLD FORMAT JSCHART...ON GRAPH SET LOOKGRAPH TREEMAP...'. (Note: My DEFINE FILE calcs are just a way to add 'variety' to GGSALES.)

This message has been edited. Last edited by: David Briars,

Hello Dave..

Thank you for the reply. I tried this in 8.0.07 and TREEMAP LOOKGRAPH is not available there..

(FOC36277) SET LOOKGRAPH HAS AN INVALID PARAMETER.


Any insights?

Thanks, Ram.

This message has been edited. Last edited by: Ramkumar - Webfous,

Ramkumar,

What is the version of the reporting server you are running? I tested the sample code from David and it worked in 8.0.0.7 environment.

Vicky Lozovsky

My Bad.. My infoAssist, webFOCUS Client is yet to be upgraded to 8.0.0.7. It is still 8.0.0.1. Will try and am sure it will work.

Thanks, Ram.