Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Dynamic header or footer in an infoassist chart
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Dynamic header or footer in an infoassist chart
 Login/Join
 
Member
posted
Hi Everyone,

Is there a way I can create a dynamic header or footer values on a PIE Chart, where values change based on the filter? for example, I have a pie chart where I need to display Total Sales, Total Profit and % of refund etc on top of pie chart these values needs to be changed based on the filters like region and year. All using infoassist GUI.

Regards
BI Dev

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


Webfocus 8105/8202
Windows
All Outputs
 
Posts: 25 | Registered: June 26, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
  

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 ibisamp/car
-* Created by Info Assist for Graph
SUM CAR.BODY.DEALER_COST
BY CAR.COMP.CAR
WHERE CAR.ORIGIN.COUNTRY EQ &COUNTRY.(FIND IBISAMP/CAR.ORIGIN.COUNTRY IN IBISAMP/CAR |FORMAT=A10,SORT=ASCENDING,REQUIRED=TRUE).COUNTRY:.QUOTEDSTRING;
HEADING
"COUNTRY: <CAR.ORIGIN.COUNTRY<+0> "
"TOTAL RETAIL COST:<TOT.CAR.BODY.RETAIL_COST<+0> "
"TOTAL DEALER COST:<TOT.CAR.BODY.DEALER_COST<+0> "
" "
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
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 PIE
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0); 
setCurveFitEquationDisplay(false); 
setPlace(true); 
setPieFeelerTextDisplay(1); 

*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
TYPE=DATA, COLUMN=N1, BUCKET=color, $
TYPE=DATA, COLUMN=N2, BUCKET=measure, $
TYPE=HEADING, JUSTIFY=LEFT, $
TYPE=HEADING, LINE=1, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $
TYPE=HEADING, LINE=1, ITEM=1, OBJECT=FIELD, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $
TYPE=HEADING, LINE=1, ITEM=2, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $
TYPE=HEADING, LINE=2, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $
TYPE=HEADING, LINE=2, ITEM=1, OBJECT=FIELD, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $
TYPE=HEADING, LINE=2, ITEM=2, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $
TYPE=HEADING, LINE=3, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $
TYPE=HEADING, LINE=3, ITEM=1, OBJECT=FIELD, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $
TYPE=HEADING, LINE=3, ITEM=2, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $
TYPE=HEADING, LINE=4, ITEM=1, OBJECT=TEXT, FONT='ARIAL', SIZE=12, COLOR=RGB(32 0 32), STYLE=NORMAL, $
*GRAPH_SCRIPT

setReportParsingErrors(false);
setSelectionEnableMove(false);
*GRAPH_JS_FINAL
"pieProperties": {
"holeSize": "65%"
},
"agnosticSettings": {
"chartTypeFullName": "Pie_Ring"
}

*END
ENDSTYLE
END

-RUN



WebFOCUS 8204, Unix, Windows
 
Posts: 1379 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Gold member
posted Hide Post
BI Dev,
In case you got lost in the code BabakNYC posted, you want to put your fields in the header, like BabakNYC put in HEADING:

quote:
"COUNTRY: <CAR.ORIGIN.COUNTRY<+0> "
"TOTAL RETAIL COST:<TOT.CAR.BODY.RETAIL_COST<+0> "
"TOTAL DEALER COST:<TOT.CAR.BODY.DEALER_COST<+0> "


Use the < sign before the field name.


WebFOCUS 8.2.03 (recent upgrade from 8105M)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 75 | Registered: December 05, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Dynamic header or footer in an infoassist chart

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.