Focal Point
[CLOSED]Drilldowns in bar chart

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1417050186

March 02, 2016, 03:20 PM
j.gross
[CLOSED]Drilldowns in bar chart
I have a simple bar chart -- say
GRAPH FILE CAR
SUM SALES
ACROSS COUNTRY
. . .
END

-- with a drilldown assigned to the bars, calling a fex procedure and passing it parameters (COUNTRY plus a whole gaggle of amper parameters).

But in real life I found that, for some values of the x-axis variable, the bar may be very short, making it difficult for the user to hit the drilldown. So I'd like to assign the same drilldown to the x-axis values (ENGLAND, FRANCE, ... in the hypothetical example), using the same type of traditional Focus STYLE syntax as I applied to the bars (rather than in the graphstyle section). But I was unable to uncover syntax that will style those bar legends along the x-axis. Can it be done? Does anyone know a magic incantation that will do it?

- - -

N.B. -- IBI gave me syntax for creating a hyperlink to a fixed url --
...
ON GRAPH SET GRAPHSTYLE *
setURL (getO1Label(), "http://www.yahoo.com"); 
...


-- but expanding on that to call Client to pass a request to Server complete with all the arguments is more work than warranted here.

This message has been edited. Last edited by: <Emily McAllister>,


- Jack Gross
WF through 8.1.05
March 03, 2016, 04:53 PM
cldiaz
Here is what I got for a response back in September when I opened a case on adding drill downs to the x axis in 8105

quote:
I have confirmed that we do not yet have the ability to add hyperlinks or drilldowns to the data labels themselves on the x or y axis. However, I am
happy to inform you that this is a new feature that will be included with the
release of WebFOCUS 8.2.00.



WebFOCUS 8204
Windows, All Outputs
August 14, 2018, 11:58 AM
Doug
Is this still true? Four Years Later? I'd really like to be able to do that. Consider my example below.

quote:
Here is what I got for a response back in September when I opened a case on adding drill downs to the x axis in 8105

"I have confirmed that we do not yet have the ability to add hyperlinks or drilldowns to the data labels themselves on the x or y axis. However, I am
happy to inform you that this is a new feature that will be included with the
release of WebFOCUS 8.2.00."


ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
-DEFAULTH &WF_HTMLENCODE=ON;
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';
DEFINE FILE CAR
BOGUS_COST/D20.2M = IF MODEL CONTAINS 'DOOR' THEN -DCOST ELSE DCOST ;
END
GRAPH FILE CAR
-* Created by Info Assist for Graph
SUM BOGUS_COST AS ''
BY CAR.CARREC.MODEL AS ''
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);
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=x-axis, $
TYPE=DATA, COLUMN=N2, BUCKET=y-axis, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDataTextPosition(1);
setFontStyle(getDataText(),3);
setTextRotation(getO1Label(),3);
*END
ENDSTYLE
END
-RUN





   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206