Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Percentages displayed on the X and Y axis scale

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Percentages displayed on the X and Y axis scale
 Login/Join
 
Gold member
posted
On October 8, 2007 I posted the following problem.

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.

Tony A provided me with the following terrific solution that works fine. I am using this solution for my html bubble graphs.

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

What I have to do now is to convert my html bubble graphs into a pdf format image. When I run my program, the percentages for the X and Y axis are not appearing. Does the above two set commands apply only to html format? If so, is there a workaround for pdf format? Pasted below is the entire code that I am using. Thanks.

GRAPH FILE GPHHOLD
SUM
ADMITS_1000
COST_ADMITS
PMPM_12MR
SNAPSHOT_MO NOPRINT
ACROSS HGROUP
ON GRAPH SET LOOKGRAPH BUBBLE
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 HOLD AS &TEMP1 FORMAT SVG
ON GRAPH SET GRAPHSTYLE *
setUseDefaultBubbleMarker(false);
setToolTipDisplay(true);
setToolTipMode(false);
setMarkerSizeDefault(100);
setUserToolTip("[SL] [R] Admits per 1000: [XV]% [R] Cost per Admit: [YV]% [R] PMPM: $[ZV] ");
setLegendAutomatic(true);
setLegendPosition(5);
setFontSize(getLegendText(),10);
setFontSizeAbsolute(getLegendText(),true);
setFontSize(getLegendText(),12);
setTextRotation(getX1Label(),0);
setTextRotation(getY1Label(),0);
setY1TitleDisplay(true);
setY1TitleString("Cost per Admit");
setY1TitleAutofit(false);
setFontSizeVC(getY1Title(),888);
setFontSizeVC(getY1Label(),888);
setX1TitleDisplay(true);
setX1TitleAutofit(false);
setX1LabelAutofit(false);
setFontSizeVC(getX1Title(),888);
setFontSizeVC(getX1Label(),888);
setX1MajorGridDisplay(false);
setY1MajorGridDisplay(false);
setY1MinorGridDisplay(false);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
-*Quadrant Lines to intersect at 0,0
setQuadrantLineValueX(0, 0);
setQuadrantLineValueY(0, 0);
setY1ScaleMaxAuto(false);
setY1ScaleMax(&BUBMAX_Y);
setX1ScaleMaxAuto(false);
setX1ScaleMax(&BUBMAX_X);
setTextFormatPreset(getX1Label(),-1);
setTextFormatPattern(getX1Label(),"#\u066A");
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#\u066A");
-SET &SIGN = IF (&BUBMAX_Y) OR (&BUBMAX_X) LE 1 THEN 'true' ELSE 'false';
setY1ScaleMaxAuto(&SIGN);
setY1ScaleMax(&BUBMAX_Y);
setX1ScaleMaxAuto(&SIGN);
setX1ScaleMax(&BUBMAX_X);
setAutofit(getTitle(),false);
setFontSize(getTitle(),12);
setFontSizeAbsolute(getTitle(),true);
setFontStyle(getTitle(),2);
setSubtitleDisplay(false);
setTitleString("Utilization and Cost (Admits)");
setRect(getTitle(),new Rectangle(-3888,11000,29806,1939));
setDisplay(getAnnotation(0), true);
setTextString(getAnnotation(0), "Admits per 1000");
setFillColor(getAnnotation(0), new Color(0,0,0));
setRect(getAnnotation(0),new Rectangle(-15999,-5000,30000,-5000));
setFontSizeAbsolute(getAnnotation(0),true);
setFontSizeInPoints(getAnnotation(0),9.0);
setFontStyle(getAnnotation(0),2);
-*setFontStyle(getY1Label(),2);
-*setFontStyle(getX1Label(),2);
setToolTipFontSize (12);
setToolTipFontStyle(3);
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,
$
TYPE=HEADING,
BACKCOLOR='BLUE',
$
TYPE=FOOTING,
BACKCOLOR='NONE',
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
STYLE=BOLD,
BOTTOMGAP=0.015889,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=4,
COLOR='WHITE',
STYLE=BOLD,
BOTTOMGAP=0.015889,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLOR='WHITE',
STYLE=BOLD,
BOTTOMGAP=0.015889,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=2,
COLOR='WHITE',
STYLE=BOLD,
BOTTOMGAP=0.015889,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=3,
COLOR='WHITE',
STYLE=BOLD,
BOTTOMGAP=0.015889,
$
TYPE=FOOTING,
LINE=4,
JUSTIFY=CENTER,
$
TYPE=FOOTING,
LINE=5,
JUSTIFY=CENTER,
$
TYPE=FOOTING,
LINE=6,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
COLOR='WHITE',
STYLE=BOLD,
BOTTOMGAP=0.015889,
$
ENDSTYLE
END
-RUN
TABLE FILE GPHHOLD
ON TABLE SUBHEAD
" - <+0> Inpatient <+42 PA"
"Utilization and Cost Trends (Admits) - Medical/Surgical/ICU Rollup"
ON TABLE SUBFOOT
"-INCLUDE app/footerfe.fex
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
LEFTMARGIN=0.500000,
RIGHTMARGIN=0.500000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.000000,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=12,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=TABHEADING,
BACKCOLOR=BLUE,
COLOR=WHITE,
$
TYPE=TABFOOTING,
LINE=34,
JUSTIFY=CENTER,
$
TYPE=TABFOOTING,
LINE=35,
JUSTIFY=CENTER,
$
TYPE=TABFOOTING,
LINE=36,
SIZE=8,
JUSTIFY=CENTER,
$
TYPE=REPORT,
IMAGE=&SVG1,
POSITION=(0.597222 1.241667),
SIZE=(8.375000 4.166667),
$
ENDSTYLE
ON TABLE PCHOLD FORMAT PDF
-*&&HOLD
END
-RUN


Webfocus version 7.1.7/Windows XP
 
Posts: 70 | Registered: April 04, 2007Report This Post
Master
posted Hide Post
I think the problem here is that PDFs themselves do not support tooltips. PDF is a primarily for-press format, even though you can view a PDF online in the Adobe PDF Viewer. So although PDF can embed the SVG with the tooltip support, it won't display the tooltips. If you use the Adobe SVG viewer or FireFox to display the SVG, you'll see the tooltip.

Hope this helped!


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

 
Posts: 919 | Registered: March 26, 2003Report This Post
Gold member
posted Hide Post
The problem is not the tool tip display. I don't expect to see the tool tip display for the pdf format version of the bubble graph. The workaround arabic percent sign code that Tony A suggested that I use works fine for the html version of the bubble graph but the arabic percent sign for the X and Y axis scale line is not showing up on the pdf version ob the bubble graph. Thanks.
 
Posts: 70 | Registered: April 04, 2007Report This Post
Virtuoso
posted Hide Post
Michele

your problem is more or less the same as displaying the EURO sign in a graph withing a PDF report.
It does not work (in version 7.1.3)




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Gold member
posted Hide Post
Thanks for the replies. I figured out what I can do in order to display the percentages correctly on the X and Y axis scale lines. I just divided my percentages by 100. Normally, dividing by 100 will affect the way the percentages are displayed in the tool tip display but since the tool tip display will not be used in the pdf version, I can divide the X and Y axis percentages by 100.
 
Posts: 70 | Registered: April 04, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Percentages displayed on the X and Y axis scale

Copyright © 1996-2020 Information Builders