I am summing two defined percent fields in a Bubble Graph request. I am using the setTextFormatPreset(getY1Label(),2); and setTextFormatPreset(getX1Label(),2); When I use this percent format, my X and Y percents are being displayed as hundreds. If I sum and compute my percent calculations and divide them by 100, my X and Y percents display the way percents should display, but this distorts my ToolTip display. Is there anyway to display the Y and X axis as normal percents instead of percents displayed in hundreds? Thanks.


WF version 7.1.7, Windows XP

Hi Michele,

For this kind of graph questions, can you please post your current code for us to take a look at? Thank you in advance for sharing with all.

Cheers,

Kerry

Michele,

Unfortunately specifying the percentage sign within Perspective for Java (the Graphstyle code) has the outcome that the value is divided by 100 before the label text is written to the data stream.

One method you could use to circumvent this shortcoming is to force the axis labels yourself as per this post by JG back in November 2005. The method is still applicable to your release.

Good luck

T

Can this type of logic work for a bubble graph. Pasted below is a sample of my bubble graph program against the CAR file. Thanks.

-* File newfex-8.fex

APP HOLD IBISAMP
SET PAGE-NUM=OFF
-*SET GRAPHENGINE = OLD

GRAPH FILE CAR
HEADING
"SAMPLE CAR REPORT"
"SUM
WHEELBASE/D7.1%
FUEL_CAP/D7.1%
DEALER_COST
ACROSS CAR
ON GRAPH SET LOOKGRAPH BUBBLE
ON GRAPH SET GRAPHEDIT OFF
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID OFF
ON GRAPH SET GRAPHSTYLE *
setUseDefaultBubbleMarker(false);
setToolTipDisplay(true);
setToolTipMode(false);
setUserToolTip("[SL] [R] Fuel Cap: [XV]% [R] Wheelbase: [YV]% [R] PMPM: $[ZV] ");
setLegendAutomatic(true);
setLegendPosition(5);
setToolTipFontSize (14);
setToolTipFontStyle (3);
setTextRotation(getX1Label(),0);
setTextRotation(getY1Label(),0);
setMarkerSizeDefault(100);
setRect(getTitle(),new Rectangle(-4888,11000,29806,1939));
setFontSizeVC(getTitle(),1222);
setY1TitleDisplay(true);
setY1TitleString("Wheelbase");
setY1TitleAutofit(false);
setFontSizeVC(getY1Title(),888);
setFontSizeVC(getY1Label(),888);
setX1TitleDisplay(true);
setX1TitleAutofit(false);
setX1LabelAutofit(false);
setX1TitleString("Fuel Cap");
setFontSizeVC(getX1Title(),888);
setFontSizeVC(getX1Label(),888);
setX1MajorGridDisplay(false);
setY1MajorGridDisplay(false);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"###");
setTextFormatPreset(getX1Label(),-1);
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setLegendDisplay(true);
setTitleString("Car File Graph");
setFontSizeAbsolute(getTitle(),true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getO1Title(),true);
setFontSize(getLegendText(),10);
setFontSizeAbsolute(getLegendText(),true);
setFontSize(getLegendText(),12);
setQuadrantLineValueX(0, 0);
setQuadrantLineValueY(0, 0);
-*setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
BOTTOMGAP=0.054889,
SIZE=10,
FONT=ARIAL,
TITLETEXT=' ',
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=10,
BACKCOLOR='NONE',
STYLE=NORMAL,
BOTTOMGAP=0.054889,
$
ENDSTYLE
END
-RUN

Hi Michele,

I had a flash of inspiration (yes, not a common occurence ) and thought of the unicode substitutions that you can do but whenever I tried the "normal" unicode value for a percentage sign it still seemed to trap it and mulitply by 100 before displaying the label.

All is not lost though if you are prepared to accept the arabic version as the SW doesn't seem to trap that one

setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#\u066A");

It looks a little odd but you can see that it is a percentage sign.

T

Hi Michele,

Has this issue been resolved for you? Please let us know.

Many thanks to Tony's input.

Cheers,

Kerry

My hat is off to Tony A. Tony, your last reply was a stoke of genius. I tried your suggestion and he looks great to me. I will try to convince the users to accept this display. I apologize for not getting back sooner. My department was involved in moving to another floor. Many Many Many thanks again to Tony A. I love it!

Michele,

Good luck in persuading your Users! As it's only for display then then shouldn't baulk too much at the wierdness of the character.

Glad to have helped.

T

Tony, just letting you know that I got user acceptance for my bubble graphs using the arabic percent sign. It appears that they didn't even notice the difference. Thanks again. You are truly a life saver.

quote:

It appears that they didn't even notice the difference

Thank god for users, sometimes.