Focal Point
[CLOSED] Chart Help - Heatmap Styling

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6727061096

May 15, 2018, 03:29 PM
Joe Beydoun
[CLOSED] Chart Help - Heatmap Styling
Couple Things:

1. I would like to invert my color scheme to where red is the highest value and green is the lowest. Not sure which part of the stylesheet does that.
2. Is it possible to create a separate legend for each value on the Y-Axis. Example, I have 3 boxes for England on this chart, I want the box with the most sales to be green not yellow compared to only England data not all the values. I'm trying to avoid creating separate charts for each value.

EXAMPLE BELOW:

ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET ARGRAPHENGINE=JSCHART
SET EMBEDHEADING=ON
SET GRAPHDEFAULT=OFF
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE car
-* Created by Info Assist for Graph
SUM CAR.SPECS.WEIGHT
BY CAR.ORIGIN.COUNTRY
BY CAR.BODY.BODYTYPE
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET AUTOFIT ON
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET LOOKGRAPH HEATMAP
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setDataTextPosition(4);
setCurveFitEquationDisplay(false);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENWarm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=DATA, COLUMN=N1, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N2, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=color, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setFillColor(getLegendArea(),new Color(255,4,4));
setTransparentFillColor(getLegendArea(),true);
setTransparentFillColor(getSeries(4), true);
setTransparentBorderColor(getSeries(4), true);
*GRAPH_JS_FINAL
"pieProperties": {
"holeSize": "0%"
},
"agnosticSettings": {
"chartTypeFullName": "Special_Spectral_Mapped"
}
*END
ENDSTYLE
END
-RUN

-*IA_GRAPH_FINISH


This message has been edited. Last edited by: FP Mod Chuck,


version 8202M
Reporting Server on
Windows Server using DB2 Connect to access data from iseries.
May 15, 2018, 04:14 PM
David Briars
If I understand your requirements correctly, this post might assist, even though you are looking at a heatmap, and the post is for a treemap:
http://forums.informationbuild...017030096#8017030096




Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster