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 Graph to be filtered based on Accordian column clicked
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Dynamic Graph to be filtered based on Accordian column clicked
 Login/Join
 
Gold member
posted
Hi,

Is there a way we can filter or change graph based on column expanded in accordian.

For example see code below , Is it possible to filter graph only for England when country England is expanded in Accordian report.

-DEFAULTH &RFRSH=0;
-DEFAULTH &CNTRY='FOC_NONE';
-*-IF &RFRSH=100 THEN GOTO SKPRPT;
TABLE FILE CAR
SUM
CAR.BODY.DEALER_COST         AS ''
BY CAR.ORIGIN.COUNTRY        AS ''
BY CAR.COMP.CAR              AS ''
BY CAR.CARREC.MODEL          AS ''
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
-*ON TABLE SET EXPANDABLE ON
ON TABLE SET EXPANDBYROW ON
ON TABLE NOTOTAL
ON TABLE HOLD AS H1 FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
DEFMACRO=COND0001,
MACTYPE=RULE,
WHEN = N1 EQ 'ENGLAND',
$
DEFMACRO=COND0002,
MACTYPE=RULE,
WHEN = N1 EQ 'FRANCE',
$
DEFMACRO=COND0003,
MACTYPE=RULE,
WHEN = N1 EQ 'ITALY',
$
DEFMACRO=COND0004,
MACTYPE=RULE,
WHEN = N1 EQ 'JAPAN',
$
DEFMACRO=COND0005,
MACTYPE=RULE,
WHEN = N1 EQ 'W GERMANY',
$
TYPE=SUBTOTAL,
    BY=1,
    COLOR=RGB(56 145 167),
 BACKCOLOR='WHITE',
 MACRO=COND0001,
$
TYPE=SUBTOTAL,
    BY=2,
    COLOR=RGB(56 145 167),
 BACKCOLOR='WHITE',
 MACRO=COND0001,
$
TYPE=SUBTOTAL,
    BY=1,
    COLOR=RGB(254 184 10),
 BACKCOLOR='WHITE',
 MACRO=COND0002,
$
TYPE=SUBTOTAL,
    BY=1,
    COLOR=RGB(195 45 46),
 BACKCOLOR='WHITE',
 MACRO=COND0003,
$
TYPE=SUBTOTAL,
    BY=1,
    COLOR=RGB(132 170 51),
 BACKCOLOR='WHITE',
 MACRO=COND0004,
$
TYPE=SUBTOTAL,
    BY=1,
    COLOR=RGB(150 67 5),
 BACKCOLOR='WHITE',
 MACRO=COND0005,
$
ENDSTYLE
END
-*-SKPRPT
TABLE FILE CAR
SUM DEALER_COST
BY CAR
ON TABLE HOLD AS H2
END
-RUN
-*
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 H2
-* Created by Info Assist for Graph
SUM DEALER_COST
BY CAR
-*WHERE COUNTRY EQ '&CNTRY'
ON GRAPH HOLD AS GRAPH01 FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT 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 GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH PIEMULTI
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(30);
setCurveFitEquationDisplay(false);
setPlace(true);
setPieFeelerTextDisplay(1);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDisplay(getLegendArea(),false);
setPieFeelerTextDisplay(3);
setDisplay(getPieLabel(),false);
-*setFillColor(getSeries(0),new Color(150,57,90));
-*setFillColor(getSeries(1),new Color(164,62,98));
-*setFillColor(getSeries(2),new Color(178,67,107));
-*setFillColor(getSeries(3),new Color(188,77,117));
-*setFillColor(getSeries(4),new Color(193,92,128));
-*setFillColor(getSeries(5),new Color(199,106,139));
-*setFillColor(getSeries(6),new Color(204,120,150));

setFillColor(getSeries(0),new Color(56,145,167));
setFillColor(getSeries(1),new Color(254,184,10));
setFillColor(getSeries(2),new Color(195,45,46));
setFillColor(getSeries(3),new Color(132,170,51));
setFillColor(getSeries(4),new Color(56,145,167));
setFillColor(getSeries(5),new Color(150,67,5));
setFillColor(getSeries(6),new Color(254,184,10));
*END
*GRAPH_JS
-*riserBevel of none makes the chart 2D delivering the flat look
"riserBevel":"none",
-*The holeSize property of a % will maintain the pie radius proportion no matter what size your chart is. This is better than using a fixed number of pixels
pieProperties: {
holeSize: '60%', label: {visible: true,	font: '10pt Arial',	color: '#666666'},
},
*END
ENDSTYLE
END
-RUN


-HTMLFORM BEGIN

<STYLE type="text/css">
.gph1 {position: absolute; top: 20px; left: 100px; }
.rpt1 {position: absolute; top: 220px; left: 0px;}
</STYLE>
-*</script>
<DIV id=GRPH1 class="gph1 ">
!IBI.FIL.GRAPH01;
</DIV>
-*-IF &RFRSH=100 THEN GOTO SKPRPT1;
<DIV id=RPT1 class="rpt1 " OnClick="document.f1.submit();" >
!IBI.FIL.H1;
</DIV>
-*-SKPRPT1
-*</HTML>
<HTML>
 <body >
  <form name=f1 action="/ibi_apps/run.bip" method="get" target="_self">
  <input type="hidden" name="BIP_REQUEST_TYPE" value="BIP_RUN">
  <input type="hidden" name="BIP_folder"       value="IBFS:/WFC/Repository/...(folder path)">
  <input type="hidden" name="BIP_item"         value="TEST.fex">
  <input type="hidden" name="Rand"             value="!IBI.AMP.Rand;">
-*  <input type="HIDDEN" name="RFRSH"  value="100" >
-*  <input type="HIDDEN" name="CNTRY"  value=COUNTRY >
  !IBI.FIL.GRAPH01;
  </body>
-HTMLFORM END
-EXIT


i am trying to target the graph to div GRPH1 instead of self and pass Country clicked to refresh the report so that I can filter the H2 graph for that variable.

Let me know any suggestions.

Thanks,
Rajna

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


WebFOCUS 8.1.05
Windows
Excel, PDF, HTML
 
Posts: 65 | Location: Flowood , MS | Registered: May 11, 2011Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Rajna

If this is still an issue please open a case with techsupport since no one has been able to provide any guidance


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1491 | Location: Customer Support | Registered: April 12, 2005Reply 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 Graph to be filtered based on Accordian column clicked

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