Focal Point
Cant do a drilldown on a Gauge graph

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

April 29, 2005, 01:22 PM
Pete
Cant do a drilldown on a Gauge graph
Hi,

We are trying to do a drilldown on a graph , type gauge , but it doesnt work
It seems to work for any graphtype except gauge , ironically thats the one we gotta use

so if you any suggestions.....

Thanks

P.
April 29, 2005, 01:31 PM
Pete
here is an example

DEFINE FILE CAR
SALES/D10=SALES/1000;
END
GRAPH FILE CAR
SUM SALES AS 'Sales for'
ACROSS COUNTRY
WHERE ( COUNTRY EQ 'ENGLAND' );
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 *
setLegendDisplay(false);
setGaugeBackgroundStyle(7);
setFillColor(getGaugeNeedle(), new Color(0,0,0));
setFillColor(getGaugeLabel(), new Color(0,0,0));
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
setScaleMaxAuto(getY1Axis(), false);
setScaleMax(getY1Axis(),90.0);
setScaleMinAuto(getY1Axis(), false);
setScaleMin(getY1Axis(),-90);
setDisplay(getGaugeBand1(),true);
setDisplay(getGaugeBand2(),true);
setDisplay(getGaugeBand3(),true);
setGaugeBandMin(getGaugeBand1(), -90);
setGaugeBandMax(getGaugeBand1(), -10);
setGaugeBandMin(getGaugeBand2(), -10);
setGaugeBandMax(getGaugeBand2(), 10);
setGaugeBandMin(getGaugeBand3(), 10);
setGaugeBandMax(getGaugeBand3(), 90);
setFillColor(getGaugeBand2(), new Color(255,255,0));
setBorderColor(getGaugeBand2(), new Color(255,255,0));
setFillColor(getGaugeBand3(), new Color(0,255,0));
setBorderColor(getGaugeBand3(), new Color(0,255,0));
-* Remove annoying box around Gauge
setDisplay(getFrame(), false);
-*setTransparentFillColor(getGaugeBackground(),true);
setGaugeTitlePosition(1);
ENDSTYLE
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
BACKCOLOR='NONE',
STYLE=NORMAL,

$
DEFMACRO=COND0001,
MACTYPE=RULE,
WHEN=N1 LT -20,
$
DEFMACRO=COND0002,
MACTYPE=RULE,
WHEN=N1 GT 20,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
FOCEXEC=TEST9.fex(),
$
TYPE=DATA,
ACROSSCOLUMN=N1,
COLOR='SILVER',
$
TYPE=DATA,
ACROSSCOLUMN=N1,
COLOR='LIME',
MACRO=COND0002,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
COLOR='RED',
MACRO=COND0001,
$

ENDSTYLE
END
May 02, 2005, 07:08 AM
Pete
I'm getting pretty desperate on this on.....so anyone