Hi Everyone,

I have created a pie chart on infoassist, which shows "Sales" by "Category", on the other hand I would like to create a detailed report, which gets generated when an user clicks on a pie slice(Category). I am able to pass either Sales or Catgeory as parameters to this detailed report. Is there a way to pass more parameters to this detailed report from the pie chart? I need to create this report using only infoassist. I would appreciate if someone can provide an insight on this.

Regards
Bi Dev

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

You can pass either the columns present in the chart, constants or variables. If there’s a column you need that’s not a part of the chart, you could try to add it to the chart and make it not visible. That will make that column also available for passing to a drill down. However, keep in mind that a user clicking a slice wouldn’t know what value you’re passing.

Hi Babak,

This pie chart will have 4 filters from date, to date, country and return status. Let's say an user enters these values and runs this pie chart, once the chart displays and they click on a pie slice these parameters(filter prompts) they have entered should also be passed on to the detailed(drill down) report.
for pie chart I can add only one dimension(on color tab) Is there a way we can achieve this using info assist or text editor for Pie chart?

You can do this using InfoAssist. When you create the Summary chart, when choosing the Drill Down parameters, pass the value of the slice using Fieldname, and for the Variables you've already collected in your prompt pass &VARIABLENAME as constant. Remember if you want your date field to be passed from your &DATEFIELD, make sure to include the & in your constant. See below for a Summary chart and Detailed drill.

  

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 retail_samples/wf_retail
-* Created by Info Assist for Graph
SUM WF_RETAIL.WF_RETAIL_SALES.REVENUE_US
BY WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG
WHERE WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE_DAY_COMPONENT EQ &TIME_DATE_DAY_COMPONENT.(FIND RETAIL_SAMPLES/WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE_DAY_COMPONENT IN RETAIL_SAMPLES/WF_RETAIL |FORMAT=YYMD,SORT=ASCENDING,REQUIRED=TRUE).Day:.QUOTEDSTRING;
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
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 PIE
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0); 
setPlace(true); 
setPieFeelerTextDisplay(1); 
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=color, $
TYPE=DATA, COLUMN=N2, ALT='detailed', TARGET='_blank', BUCKET=measure, FOCEXEC=IBFS:/WFC/Repository/Retail_Samples/detailed.fex(PRODUCT_SUBCATEG=WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG TIME_DATE_DAY_COMPONENT=&TIME_DATE_DAY_COMPONENT.QUOTEDSTRING), $
*GRAPH_SCRIPT

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

*END
ENDSTYLE
END

-RUN

Detailed drill report:

  

ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET SQUEEZE=ON
-DEFAULTH &WF_HTMLENCODE=ON;
SET HTMLENCODE=&WF_HTMLENCODE

SET HTMLCSS=ON
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT

-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
-DEFAULT &TIME_DATE_DAY_COMPONENT = _FOC_NULL;
-DEFAULT &PRODUCT_SUBCATEG = _FOC_NULL;
TABLE FILE retail_samples/wf_retail
SUM WF_RETAIL.WF_RETAIL_SALES.REVENUE_US
BY WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG
BY WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE_DAY_COMPONENT
WHERE WF_RETAIL.WF_RETAIL_TIME_SALES.TIME_DATE_DAY_COMPONENT EQ &TIME_DATE_DAY_COMPONENT.(|FORMAT=YYMD).Day:.QUOTEDSTRING;
WHERE WF_RETAIL.WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG EQ &PRODUCT_SUBCATEG.(|FORMAT=A50V).Product Subcategory:.QUOTEDSTRING;
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET GRWIDTH 1
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
ENDSTYLE
END

-RUN

Thank you very much Babak, I passed drilldown parameters as constant. It worked.

Regards
BI Dev