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     [CLOSED] Display Percent Sign in Chart within InfoAssist

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Display Percent Sign in Chart within InfoAssist
 Login/Join
 
Expert
posted
What's wrong with this? The numeric value of the percentages is correct. But, what I'm missing is the percent sign on the line chart. The percent sign is displayed properly when you hover over the value.

BTW: This needs to be accomplished within InfoAssist 8204.

-*COMPONENT=Define_car
DEFINE FILE baseapp/car
DF_Profit_Amount/D12M=CAR.BODY.RETAIL_COST - CAR.BODY.DEALER_COST ;
DF_Profit_Percent/D6.2%=((CAR.BODY.RETAIL_COST - CAR.BODY.DEALER_COST) / CAR.BODY.DEALER_COST ) * 100;
END
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
-DEFAULTH &WF_HTMLENCODE=OFF;
SET HTMLENCODE=&WF_HTMLENCODE

SET ARGRAPHENGINE=JSCHART
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT

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 baseapp/car
-* Created by Info Assist for Graph
SUM CAR.BODY.RETAIL_COST
CAR.BODY.DEALER_COST
DF_Profit_Amount
DF_Profit_Percent/D6.1%
BY CAR.CARREC.MODEL
WHERE CAR.CARREC.MODEL LE '2002 2 DOOR AUTO';
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/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
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(1), $
TYPE=DATA, COLUMN=N5, BUCKET=y-axis(2), $
*GRAPH_SCRIPT

setReportParsingErrors(false);
setSelectionEnableMove(false);
setSeriesType(3,2);
setDataTextPosition(1);
setDisplay(getDataText(3), true);
setTextFormatPreset(getY2Label(),2);
setDisplay(getLegendArea(),false);
setCustomDataText(getDataText(3), true);
setTextFormatPreset(getDataText(3), 0);
setTransparentBorderColor(getSeries(*), true);
setSeriesType(2,1);
*GRAPH_JS_FINAL
"pieProperties": {
"holeSize": "0%"
},
"riserBevel": "cylinder",
"agnosticSettings": {
"dual": true,
"chartTypeFullName": "Bar_Clustered_Dual_Axis"
}

*END
ENDSTYLE
END

-RUN
It's gotta be something simple, right?

This message has been edited. Last edited by: FP Mod Chuck,




   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, 2005Report This Post
Virtuoso
posted Hide Post
In InfoAssist, change your percent by removing the * 100. Then right click the label on the line chart and choose More Labels Options...

For the Format Labels pick Percent with two decimals.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Expert
posted Hide Post
Babak,

I got that. But, the display is '0' on hover...

-*COMPONENT=Define_car
DEFINE FILE baseapp/car
DF_Profit_Amount/D12M=CAR.BODY.RETAIL_COST - CAR.BODY.DEALER_COST;
DF_Profit_Percent/D6=(CAR.BODY.RETAIL_COST - CAR.BODY.DEALER_COST) / CAR.BODY.DEALER_COST;
END
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
-DEFAULTH &WF_HTMLENCODE=OFF;
SET HTMLENCODE=&WF_HTMLENCODE

SET ARGRAPHENGINE=JSCHART
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT

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 baseapp/car
-* Created by Info Assist for Graph
SUM CAR.BODY.RETAIL_COST
CAR.BODY.DEALER_COST
DF_Profit_Amount
DF_Profit_Percent
BY CAR.CARREC.MODEL
WHERE CAR.CARREC.MODEL LE '2002 2 DOOR AUTO';
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); 
setCurveFitEquationDisplay(false); 
setPlace(true); 

*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
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(1), $
TYPE=DATA, COLUMN=N5, BUCKET=y-axis(2), $
*GRAPH_SCRIPT

setReportParsingErrors(false);
setSelectionEnableMove(false);
setTransparentBorderColor(getSeries(*), true);
setDataTextPosition(1);
setCustomDataText(getDataText(3), true);
setTextFormatPreset(getDataText(3), 4);
setSeriesType(3,2);
setTextFormatPreset(getY2Label(),4);
setFontName(getDataText(3), "ARIAL BLACK");
setFontSizeAbsolute(getDataText(3), true);
setFontSizeInPoints(getDataText(3), 12);
setPlaceResize(getDataText(3), 0);
setDisplay(getDataText(3), true);
setPieFeelerTextDisplay(1);
*GRAPH_JS_FINAL
"pieProperties": {
"holeSize": "0%"
},
"riserBevel": "cylinder",
"agnosticSettings": {
"dual": true,
"chartTypeFullName": "Bar_Clustered_Dual_Axis"
}

*END
ENDSTYLE
END

-RUN

 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Virtuoso
posted Hide Post
As you probably already have noticed, it display 0 because your define do not include any decimal
DF_Profit_Percent/D6

Having defined as
DF_Profit_Percent/D6.2

will show the value but as a decimal one and not as a percentage such as in the DataText.

Since the percentage value is calculate internally based on selected display format,
I think that to have it displayed in the same way within the hover tooltip (20.55%) you need to use the customized tooltip which I don't think it's possible using IA


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Expert
posted Hide Post
The D6.2 does show the two decimal places. But as a decimal, not as the percent as seen in the label of the line chart as required. Frowner

... "which I don't think it's possible using IA" ... Frowner

 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Platinum Member
posted Hide Post
Doug,

In the past I put the percent sign in the Label. So in this case DF_Profit_Percent %. This will over do it but it is an option. This makes it a little bit easier to explain to the different Business partners that are able to create objects to be used in their groups.


dksib
DC Tech Services Inc
WF 8.2.1M
 
Posts: 117 | Location: US | Registered: February 09, 2004Report This Post
Expert
posted Hide Post
So, it looks like it cannot be done from within IA, Right?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Virtuoso
posted Hide Post
quote:
Originally posted by David Sibert:

In the past I put the percent sign in the Label. So in this case DF_Profit_Percent %.

Could be a great option, but the issue is that it will display
DF_Profit_Percent % 0.20

When in reality it is (such as in the DataText)
DF_Profit_Percent % 20.55


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Expert
posted Hide Post
NFR or Hopes that it'll be in the 8205 Designer.

OR I'll tag this as a NFR as that may push it to ensure it gets




   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, 2005Report 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     [CLOSED] Display Percent Sign in Chart within InfoAssist

Copyright © 1996-2020 Information Builders