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.
Hello All, I have a dual axis graph with Bars and Lines.
I dont want to display the legends for Lines, just the Bar. I was checking some options and using annotations looks like the best option. The challenge I am facing is how to add multiple annotations on the same garph. Have a look at the below code, should give you an idea of what I am trying to do.
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET ARGRAPHENGINE=JSCHART
SET EMBEDHEADING=ON
SET GRAPHDEFAULT=OFF
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE ggsales
-* Created by Info Assist for Graph
SUM GGSALES.SALES01.DOLLARS
GGSALES.SALES01.BUDDOLLARS
PCT.GGSALES.SALES01.DOLLARS
PCT.GGSALES.SALES01.BUDDOLLARS
BY GGSALES.SALES01.ST
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET AUTOFIT ON
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Target.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N2, BUCKET=y-axis(1), $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis(1), $
TYPE=DATA, COLUMN=N4, BUCKET=y-axis(2), $
TYPE=DATA, COLUMN=N5, BUCKET=y-axis(2), $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setSeriesType(2,2);
setSeriesType(3,2);
*GRAPH_JS_FINAL
"pieProperties": {
"holeSize": "0%"
},
"agnosticSettings": {
"dual": true,
"chartTypeFullName": "Bar_Clustered_Dual_Axis"
},
"legend": {"visible":false},
"annotations": [{
"position": {
"x": "10%",
"y": "98%",
"parent": "background"},
"marker": {"visible": true, "color": "blue",
"shape": "fiveStar", "rotation": 0,
"border": {"width": 1, "color": "black", "dash": ""}},
"label": {"visible": true, "text": "Series annotation",
"font": "10pt Times New Roman", "color": "black", "position":
"right"}
}]
*END
ENDSTYLE
END
-RUN
This message has been edited. Last edited by: Addy,
WF 8.2.04 Windows/Unix All Formats In Focus since 2006
Posts: 74 | Location: UK | Registered: September 17, 2018
Originally posted by Tony A: You might be over thinking this Addy, try -
"legend": {maxEntries: 2},
T
Hi Tony, Sorry for a misleading example. My code is similar to the one below. I want to display only the Bar Legends hide Line legends. when checked the forum, someone suggested using annotations might be a solution, and it works. Problem is how to add multiple annotations. If there is a workaround or some other approach more than happy to implement it.
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET ARGRAPHENGINE=JSCHART
SET EMBEDHEADING=ON
SET GRAPHDEFAULT=OFF
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE ggsales
-* Created by Info Assist for Graph
SUM GGSALES.SALES01.DOLLARS
PCT.GGSALES.SALES01.BUDDOLLARS
BY GGSALES.SALES01.PRODUCT
BY GGSALES.SALES01.REGION
WHERE GGSALES.SALES01.PRODUCT EQ 'Capuccino' OR 'Espresso';
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=DATA, COLUMN=N1, BUCKET=color, $
TYPE=DATA, COLUMN=N2, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis(1), $
TYPE=DATA, COLUMN=N4, BUCKET=y-axis(2), $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setSeriesType(1,2);
setSeriesType(3,2);
setMarkerShape(getSeries(3),3);
setMarkerShape(getSeries(1),2);
*GRAPH_JS_FINAL
"pieProperties": {
"holeSize": "0%"
},
"agnosticSettings": {
"dual": true,
"chartTypeFullName": "Bar_Clustered_Dual_Axis"
},
"annotations": [{
"position": {
"x": "10%",
"y": "98%",
"parent": "background"},
"marker": {"visible": true, "color": "blue",
"shape": "fiveStar", "rotation": 0,
"border": {"width": 1, "color": "black", "dash": ""}},
"label": {"visible": true, "text": "Series annotation",
"font": "10pt Times New Roman", "color": "black", "position":
"right"}
}]
*END
ENDSTYLE
END
-RUN
WF 8.2.04 Windows/Unix All Formats In Focus since 2006
Posts: 74 | Location: UK | Registered: September 17, 2018
I want to display only the Bar Legends hide Line legends.
Not misleading I think, I was suggesting that you do not have to resort to using annotations as there is a perfecty simple method of achieving just 2 entries within the legend (providing your measures are in the right order).
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, 2004
However, if you really want to go to the multiple annotations then you just need to extend the array of annotations. You already have the code, you just need to add another annotation to your array -
Thansk Tony, I tried this earlier but it just got replaced by the second value. I am sure i must have missed something as your solution is working as expected.
WF 8.2.04 Windows/Unix All Formats In Focus since 2006
Posts: 74 | Location: UK | Registered: September 17, 2018