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     Display data values in graph - Bubble Graph

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Display data values in graph - Bubble Graph
 Login/Join
 
Gold member
posted
Hi,
I am creating a bubble graph where in , I need to show the one of the column data values near the bubbles in the graph.

I have pasted the code which I am trying with, in this I have a column fund_scheme_name which has names of the funds, I need to show these names near the bubbles. I can able to show other below values near the bubbles
ie
RTN_PER - [x]
STANDARD_DEVTN - [y]
CORPUS1 - [SIZE]

using the graph API, setDataTextTemplateBubble("<[Y]/[X]>");


Similarly, I need to show the names of the funds in the bubbles, Can any of you help me in this.



GRAPH FILE HOLD
SUM RTN_PER STANDARD_DEVTN CORPUS1 AS 'FUNDCODE'
BY FUND_SCHEME_NAME
ON GRAPH SET LOOKGRAPH BUBBLE
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D ON
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON

-TYPE &&RPT_TYPE
-IF &&RPT_TYPE EQ 'HTML' THEN GOTO HTMFORM ELSE IF &&RPT_TYPE EQ 'XLS' THEN GOTO XLSFORM ELSE GOTO PDFFORM;
-HTMFORM
ON GRAPH SET VAXIS 600
ON GRAPH SET HAXIS 800

-GOTO FORMEXIT
-XLSFORM
ON GRAPH HOLD AS BUBCHART FORMAT GIF
-GOTO FORMEXIT
-PDFFORM
ON GRAPH SET VAXIS 20
ON GRAPH SET HAXIS 20
ON GRAPH HOLD AS BUBBLEGRAPH FORMAT SVG
-FORMEXIT
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBIFadeToGrey.txt");
setReportParsingErrors(false);
setLineWidth(getQuadrantLine(),1);
setCubeSquareRisers(false);
setSelectionEnableMove(false);
setDepthRadius(0);
setMarkerSizeDefault(100);
setSeriesType(0, 0);
setConnectLineStep(getSeries(0),false);
setMarkerShape(getSeries(0), 2);
setSeriesFillColor(getSeries(0),new Color(140,175,239));
setSeriesType(1, 0);
setConnectLineStep(getSeries(1),false);
setMarkerShape(getSeries(1), 2);
setSeriesFillColor(getSeries(1),new Color(140,175,239));
setSeriesType(2, 0);
setConnectLineStep(getSeries(2),false);
setRiserWidth(70);
setMarkerShape(getSeries(2), 2);
setSeriesFillColor(getSeries(2),new Color(140,175,239));
setSeriesType(3, 0);
setConnectLineStep(getSeries(3),false);
setMarkerShape(getSeries(3), 2);
setSeriesFillColor(getSeries(3),new Color(140,175,239));
setSeriesType(4, 0);
setConnectLineStep(getSeries(4),false);
setMarkerShape(getSeries(4), 2);
setSeriesFillColor(getSeries(4),new Color(140,175,239));
setSeriesType(5, 0);
setConnectLineStep(getSeries(5),false);
setMarkerShape(getSeries(5), 2);
setMarkerShape(getSeries(6), 2);
setMarkerShape(getSeries(7), 2);
setMarkerShape(getSeries(8), 2);
setMarkerShape(getSeries(9), 2);
setMarkerShape(getSeries(10), 2);
setMarkerShape(getSeries(11), 2);
setMarkerShape(getSeries(12), 2);
setMarkerShape(getSeries(13), 2);
setMarkerShape(getSeries(14), 2);
setMarkerShape(getSeries(15), 2);
setMarkerShape(getSeries(16), 2);
setMarkerShape(getSeries(17), 2);
setMarkerShape(getSeries(18), 2);
setMarkerShape(getSeries(19), 2);
setMarkerShape(getSeries(20), 2);
setMarkerShape(getSeries(21), 2);
setMarkerShape(getSeries(22), 2);
setMarkerShape(getSeries(23), 2);
setMarkerShape(getSeries(24), 2);
setMarkerShape(getSeries(25), 2);
setMarkerShape(getSeries(26), 2);
setMarkerShape(getSeries(27), 2);
setMarkerShape(getSeries(28), 2);
setMarkerShape(getSeries(29), 2);
setMarkerShape(getSeries(30), 2);
setSmoothLines(false);
setSmoothAreas(false);
setUseTimeScaleAxis(false);
setReverseSeries(false);
setSeriesLooping(1);
setY2AxisSide(0);
setY2MajorGridDisplay(false);
setY2MinorGridDisplay(false);
setLegendMarkerPosition(1);
setMarkerDisplay(true);
setUseSeriesShapes(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(false);
setO1MajorGridDisplay(false);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setAxisAssignment(1,0);
setAxisAssignment(2,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setTitleString("Risk Return Charting");
setY1MajorGridDisplay(false);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setLegendDisplay(true);
setLegendReverse(true);
setFontName(getLegendText(),"Serif");
setFontSizeAbsolute(getLegendText(),true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setDisplay(getX1MajorGrid(),false);
setDisplay(getY1MajorGrid(),false);
setDataTextTemplateBubble("<[Y]/[X]>");


setDataTextDisplay (true);


ENDSTYLE
ON GRAPH SET STYLE *
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
TYPE=DATA,
COLUMN=N2,
COLOR=RGB(140 175 239),
$
ENDSTYLE
END

Thanks
Cnu


WF 8.0.0.9 Database : oracle

CURRENT:
WebFOCUS 8.0.0.9 /oracle 11 i

 
Posts: 51 | Registered: September 20, 2007Report This Post
Expert
posted Hide Post
Cnu,

It would appear that you are using Srini's userid? Why do you not create your own?

If you use the link top right and search the forum for "bubble graph" you will find many previous posts, also search for "data label" etc.

Also, get hold of a copy of the graphics manual from the IB website, the link has been given to Srini before in this post. Perhaps he has already downloaded it and will share with you?

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report 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     Display data values in graph - Bubble Graph

Copyright © 1996-2020 Information Builders