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.
All I really want is to make the width of the horizontal bar wider to fill in the iFrame.
You can see, via the below links, what I'm talking about here. I have six stacked bars and one 4 row / wide report on my KPI page in the portal, So, the real estate is tight, as seen below. I am currently overlapping the bars as to maximize the real estate. But that's just a pain to maintain.
1) As seen in AppStudio:
* The iFrame is the only thing in this HTML/Document, 1000 wide by 100 tall.
* I want the chart to fill the entire iFrame (orange area).
2) As seen in IE:
* The chart should fill the yellow and orange areas wide the gray lines removed.
Here's the code for the fex (Chart), created 100% in the GUI:
-* File: IBFS:/Dev/WFC/Repository/Vendor/Doug/Chart1.fex Created by WebFOCUS AppStudio
-*IA_GRAPH_BEGIN
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT *** I deleted this section for the sake of space in this post
-*Do not delete or modify the comments above
ENGINE INT CACHE SET ON
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE car
-* Created by Info Assist for Graph
SUM CAR.BODY.DEALER_COST AS ''
CAR.BODY.RETAIL_COST AS ''
CAR.BODY.DEALER_COST AS ''
CAR.BODY.RETAIL_COST AS ''
BY LOWEST 1 CAR.ORIGIN.COUNTRY AS '' NOPRINT
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET EMBEDHEADING ON
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/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=DATA, COLUMN=N1, BUCKET=row, $
TYPE=DATA, COLUMN=N2, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N4, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N5, BUCKET=y-axis, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDisplay(getLegendArea(),false);
setDisplay(getO1Label(),false);
setDisplay(getY1Label(),false);
setDisplay(getY1AxisLine(),false);
setDisplay(getY1ZeroLine(),false);
setScaleMinAuto(getY1Axis(),false);
setScaleMaxAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),166344.0);
setGridStepAuto(getY1MajorGrid(),false);
setScaleMustIncludeZero(getY1Axis(),false);
setDisplay(getDataText(),true);
setStackedDataValueSum(false);
setZeroValueDataTextStackedTotalOnTopDisplay(false);
setDataTextDisplay(true);
setPieFeelerTextDisplay(1);
setDataTextPosition(4);
setTransparentFillColor(getFrameSide(),true);
setTransparentBorderColor(getFrameSide(),true);
setTransparentFillColor(getFrameBottom(),true);
setTransparentBorderColor(getFrameBottom(),true);
setDepthAngle(0);
setDisplay(getO1AxisLine(),false);
setConnectLineMarkers(true);
setGridStep(getY1MajorGrid(),166344.0);
*GRAPH_JS_FINAL
"pieProperties": {
"holeSize": "0%"
},
"blaProperties": {
"seriesLayout": "stacked",
"orientation": "horizontal"
},
"agnosticSettings": {
"chartTypeFullName": "Bar_Stacked_Horizontal"
}
*END
ENDSTYLE
END
-RUN
-*IA_GRAPH_FINISH
Thanks in advance, DougThis message has been edited. Last edited by: Doug,
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005
The width of a bar in a JSCHART bar graph is largely governed by the barGroupGapWidth value. In the case of your procedure, adding a line in the *GRAPH_JS "blaProperties" section setting this value to 0:
Chuck, Yes this is used in a portal. The entire HTML page is one item with the bars in it. I can't use AutoSize in that I need to set "setScaleMax(getY1Axis(),166344.0);", where '166344' is the sum total to all bar segments.
Donal, I added that line of code and I get nothing but a blank screen. Would you try it with my original code and let us know if it works for you? It may be a system setting. Let us know if you change anything else to make it work.
Tony, Forgive me for not going there (using your proven techniques). After all, we know that We Can Do That In WebFOCUS!. I'll post the new code after I get it to work ( unless you beat me to it )This message has been edited. Last edited by: Doug,
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005
-* File: IBFS:/Dev/WFC/Repository/Vendor/Doug/Chart1.fex Created by WebFOCUS AppStudio -*IA_GRAPH_BEGIN -*Do not delete or modify the comments below *-INTERNAL_COMMENT *** I deleted this section for the sake of space in this post -*Do not delete or modify the comments above ENGINE INT CACHE SET ON -DEFAULTH &WF_STYLE_UNITS='PIXELS'; -DEFAULTH &WF_STYLE_HEIGHT='405.0'; -DEFAULTH &WF_STYLE_WIDTH='770.0'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; GRAPH FILE car -* Created by Info Assist for Graph SUM CAR.BODY.DEALER_COST AS '' CAR.BODY.RETAIL_COST AS '' CAR.BODY.DEALER_COST AS '' CAR.BODY.RETAIL_COST AS '' BY LOWEST 1 CAR.ORIGIN.COUNTRY AS '' NOPRINT ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET VZERO OFF ON GRAPH SET HTMLENCODE ON ON GRAPH SET GRAPHDEFAULT OFF ON GRAPH SET EMBEDHEADING ON 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/Warm.sty,$ TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $ TYPE=DATA, COLUMN=N1, BUCKET=row, $ TYPE=DATA, COLUMN=N2, BUCKET=y-axis, $ TYPE=DATA, COLUMN=N3, BUCKET=y-axis, $ TYPE=DATA, COLUMN=N4, BUCKET=y-axis, $ TYPE=DATA, COLUMN=N5, BUCKET=y-axis, $ *GRAPH_SCRIPT setReportParsingErrors(false); setSelectionEnableMove(false); setDisplay(getLegendArea(),false); setDisplay(getO1Label(),false); setDisplay(getY1Label(),false); setDisplay(getY1AxisLine(),false); setDisplay(getY1ZeroLine(),false); setScaleMinAuto(getY1Axis(),false); setScaleMaxAuto(getY1Axis(),false); setScaleMax(getY1Axis(),166344.0); setGridStepAuto(getY1MajorGrid(),false); setScaleMustIncludeZero(getY1Axis(),false); setDisplay(getDataText(),true); setStackedDataValueSum(false); setZeroValueDataTextStackedTotalOnTopDisplay(false); setDataTextDisplay(true); setPieFeelerTextDisplay(1); setDataTextPosition(4); setTransparentFillColor(getFrameSide(),true); setTransparentBorderColor(getFrameSide(),true); setTransparentFillColor(getFrameBottom(),true); setTransparentBorderColor(getFrameBottom(),true); setDepthAngle(0); setDisplay(getO1AxisLine(),false); setConnectLineMarkers(true); setGridStep(getY1MajorGrid(),166344.0); *GRAPH_JS_FINAL "pieProperties": { "holeSize": "0%" }, "blaProperties": { "seriesLayout": "stacked", "orientation": "horizontal", "barGroupGapWidth": 0 }, "agnosticSettings": { "chartTypeFullName": "Bar_Stacked_Horizontal" } *END ENDSTYLE END -RUN
-*IA_GRAPH_FINISH
This causes the bar to fill to the yellow area of your image. As Tony mentions, getting the graph into the orange is a bit of a different beast.
How Are You Functioning With Inline Visualization?
Many reporting requirements can call for inline visualization to be applied on a row, but out-of-the-box visualization solutions may not suit the purpose. In this session, you'll find out how to harness Functions and JavaScript to meet that requirement now that HTML standards have progressed.