I am using this example that I found on focal point,because it helps with a issue I am having.Can someone tell me why I am not getting three bands of red,yellow and green? The third band for some reason is going back to red.

 SET HOLDLIST=PRINTONLY
DEFINE FILE GGSALES
YEAR/I4=EDIT(EDIT(EDIT(DATE),'9999'));
DOLLARSLY/I8=IF YEAR EQ 1996 THEN DOLLARS ELSE 0;
BUDDOLLARSLY/I8=IF YEAR EQ 1996 THEN BUDDOLLARS ELSE 0;
BUDDOLLARSTY/I8=IF YEAR EQ 1997 THEN BUDDOLLARS ELSE 0;
END
TABLE FILE GGSALES
SUM DOLLARSLY BUDDOLLARSLY BUDDOLLARSTY
BY REGION
WHERE YEAR EQ 1996 OR 1997
ON TABLE HOLD AS H1
END
-RUN

TABLE FILE H1
SUM AVE.DOLLARSLY NOPRINT
COMPUTE YELLOWMIN/I9= C1 * .8;
COMPUTE YELLOWMAX/I9= C1;
COMPUTE GREENMIN/I9=C1 * 1.1;
COMPUTE FULLD/D12.6=((AVE.BUDDOLLARSTY * 1.2)/1000000)+.5; NOPRINT
COMPUTE FULL/I9=INT(FULLD)*1000000;
ON TABLE HOLD AS VALUES FORMAT ALPHA
END
-RUN
-READ VALUES &YELLOWMIN.A9. &YELLOWMAX.A9. &GREENMIN.A9. &FULL.A9.
GRAPH FILE GGSALES
HEADING CENTER
"Regional Sales performance 1997 vs 1996"
SUM COMPUTE DOLLAR = 100;
ACROSS REGION
WHERE YEAR EQ 1997
ON GRAPH SET LOOKGRAPH GAUGE1
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRAPHSTYLE *

setScaleMaxAuto(false);
setScaleMax(getY1Axis(),&FULL.EVAL);

setGaugeBandMin(getGaugeBand1(), 0);
setGaugeBandMax(getGaugeBand1(), 50);
setGaugeBandMin(getGaugeBand2(), 51);
setGaugeBandMax(getGaugeBand2(), 80);
setGaugeBandMin(getGaugeBand3(), 81);
setGaugeBandMax(getGaugeBand3(), 100);
setGaugeBandMin(getGaugeBand4(), 100);
setGaugeBandMax(getGaugeBand4(), 100);

setBorderColor(getGaugeBand1(),new Color(255,0,0));
setBorderColor(getGaugeBand2(),new Color(255,255,0));
setBorderColor(getGaugeBand3(),new Color(0,255,0));
setBorderColor(getGaugeBand4(),new Color(0,255,0));

setFillColor(getGaugeBand1(),new Color(255,0,0));
setFillColor(getGaugeBand2(),new Color(255,255,0));
setFillColor(getGaugeBand3(),new Color(0,255,0));
setFillColor(getGaugeBand4(),new Color(0,255,0));

setFontSizeAbsolute( getGaugeLabel(), true );
setFontSize( getGaugeLabel(), 9 );
setGaugeTitlePosition(3);
setSeriesLabel(0," ");
setPlace(false);
ENDSTYLE

END 

This message has been edited. Last edited by: Kerry,

Because, it's really not the THIRD "BAND"? Consider the following...

setGaugeBandMin(getGaugeBand1(), 0);
setGaugeBandMax(getGaugeBand1(), 50);
setGaugeBandMin(getGaugeBand2(), 51);
setGaugeBandMax(getGaugeBand2(), 80);
setGaugeBandMin(getGaugeBand3(), 81);
setGaugeBandMax(getGaugeBand3(), 100);
setGaugeBandMin(getGaugeBand4(), 100);
setGaugeBandMax(getGaugeBand4(), 100);

Then change the last three 100's to, something like 90, 91, 100... Then see if you can take it from there... HINT: Is the "X" in "GaugeBandX" referring to the Gauge?

If you are saying that the getgaugebandX does not refer to the beginning and ending of that section of the graph, then I am really in trouble. The users have requested a guage graph that show3 three colors in percentages, 0-50% is red,51-80% is yellow, and 81 - 100% is green. How can I display this on the gauge?

Even though the PFJ manual lists "setGaugeBandMax" and the min equivalent, the 7.6 graphing manual does not. This leads me to believe that perhaps IB have disabled this setting as not amount of tweaking has produced consistant results.

If I were you, I would raise a case and get the determination on whether this is supported or not.

T

Tony's quite correct GaugeBandMin/Max are not documented in the WF manual.

However there is a bug/feature or is it feaure/bug

set the Min/Max values for band 4 & 5 to a value way off scale and it works.

setGaugeBandMin(getGaugeBand1(), 0);
setGaugeBandMax(getGaugeBand1(), 50);
setGaugeBandMin(getGaugeBand2(), 51);
setGaugeBandMax(getGaugeBand2(), 80);
setGaugeBandMin(getGaugeBand3(), 81);
setGaugeBandMax(getGaugeBand3(), 100);
setGaugeBandMin (getGaugeBand4(),999 );
setGaugeBandMax (getGaugeBand4(), 999 );
setGaugeBandMin (getGaugeBand5(), 999 );
setGaugeBandMax (getGaugeBand5(), 999 );

This example works for us:

setY1ScaleMaxAuto(false);
setY1ScaleMax(100.0);
setY1ScaleMinAuto(false);
setY1ScaleMin(0.0);
setY1MajorGridStepAuto(false);
setY1MinorGridStepAuto(false);

setGaugeBandMin(getGaugeBand1(),0);
setGaugeBandMax(getGaugeBand1(),50.0);
setFillColor (getGaugeBand1(),new Color(255,128,128));
setBorderColor (getGaugeBand1(),new Color(255,128,128));

setGaugeBandMin(getGaugeBand2(),50.0);
setGaugeBandMax(getGaugeBand2(),80.0);
setFillColor (getGaugeBand2(),new Color(255,255,128));
setBorderColor (getGaugeBand2(),new Color(255,255,128));

setGaugeBandMin(getGaugeBand3(),80.0);
setGaugeBandMax(getGaugeBand3(),100.0);
setFillColor (getGaugeBand3(),new Color(128,255,128));
setBorderColor (getGaugeBand3(),new Color(128,255,128));

setGaugeBandMin(getGaugeBand4(),100.0);
setGaugeBandMax(getGaugeBand4(),110.0);
setFillColor (getGaugeBand4(),new Color(128,255,128));
setBorderColor (getGaugeBand4(),new Color(128,255,128));

setGaugeBandMin(getGaugeBand5(),110.0);
setGaugeBandMax(getGaugeBand5(),120.0);
setFillColor (getGaugeBand5(),new Color(128,255,128));
setBorderColor (getGaugeBand5(),new Color(128,255,128));

OK, either way works great!!! The 999 as well as the 110 - 120, but lets say I change the compute statement to 59.

SUM COMPUTE DOLLAR = 59;

Then the max band becomes 60 instead of 100. Why is that?

Donald,

See my previous post regarding getting the official support line from iB

T

Ok, Tony, I will create a case with IBI.