Focal Point
[CLOSED] Drill Down Tooltip on chart not showing

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

November 26, 2018, 03:19 PM
srajeevan
[CLOSED] Drill Down Tooltip on chart not showing
Hi,

I have a dual axis vertical bar chart.
I added a drill down chart to one the vertical field.On running i noticed that there is no tool tip for the drill down.
When i added another drill down to the same vertical field ,then the tool tip is showing.

Actually i need only one drill down and if i have only one drill down,the user won't see any tool tip for drill down on hover over.

I have never noticed this.

This is the code when i add drill down the vertical field.

  
TYPE=DATA, COLUMN=N3, ALT='Click here for detail chart', TARGET='_blank', BUCKET=y-axis(2), 
FOCEXEC=IBFS:/WFC/Repository/InfoApps/SalesCount_Hours_Ch_Drill1.fex(
DISTRICT_ID=DIM_LOCATION.DISTRICT_ID), 
$


Even though there is ALT = 'Click here for detail chart',it is not showing as a tool tip.

Any idea why this is happening?

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


WF8206,Windows 7,8,10
HTM,PDF,EXCEL
November 26, 2018, 04:09 PM
BabakNYC
This seems to be working for me. Does it work for you?
  

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 CAR
-* Created by Info Assist for Graph
SUM CAR.BODY.DEALER_COST
CAR.BODY.SALES
CAR.BODY.RETAIL_COST
BY CAR.COMP.CAR
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, ALT='Report1', TARGET='_blank', BUCKET=y-axis(1), FOCEXEC=IBFS:/WFC/Repository/Retail_Samples/Report1.fex(CAR=CAR.COMP.CAR), $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis(2), $
TYPE=DATA, COLUMN=N4, BUCKET=tooltip, $
*GRAPH_SCRIPT

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

*END
ENDSTYLE
END

-RUN




WebFOCUS 8206, Unix, Windows
November 26, 2018, 04:27 PM
srajeevan
Nope.It is not working for me.
There is tooltip,but only CAR,DEALER_COST and RETAIL_COST.


WF8206,Windows 7,8,10
HTM,PDF,EXCEL
November 27, 2018, 03:52 AM
Tony A
How about using a custom tooltip?

Look at this document for ideas.

There are also other, previous, posts which provide examples and methods. If I remember there was an excellent post by Gavin a few years back (Found the link).

Also remember that your question may have been asked before, so a search should always be your first option - it could save you so much time.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
November 27, 2018, 07:49 AM
MartinY
srajeevan,

It seems to be a versioning issue. Babak is on 8203. I've tested his code on my 8201 and it doesn't display the ALT. Only drillable on first y axis since it's the only one with a drill option which is okay.


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
November 27, 2018, 11:32 AM
Tony A
quote:
doesn't display the ALT

Nor in 8.2.02, 8.2.03 (don't think Babak realises that it is missing the ALT text in the tooltip), 8.2.04 or 8.2.05.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
November 27, 2018, 12:07 PM
BabakNYC
My misunderstanding. The Drill menu description displays as a tooltip only if you have multiple drilldowns. I'm not quite sure what ALT= does other than document what you're doing. This might be worth a tech support call.

  

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 CAR
-* Created by Info Assist for Graph
SUM CAR.BODY.DEALER_COST
CAR.BODY.SALES
CAR.BODY.RETAIL_COST
BY CAR.COMP.CAR
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 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), DRILLMENUITEM='Click Here for Rep 1', TARGET='_blank', FOCEXEC=IBFS:/WFC/Repository/Retail_Samples/Report1.fex(CAR=CAR.COMP.CAR), DRILLMENUITEM='This is report 2', TARGET='_blank', FOCEXEC=IBFS:/WFC/Repository/Retail_Samples/Report2.fex(CAR=CAR.COMP.CAR), $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis(2), $
TYPE=DATA, COLUMN=N4, BUCKET=tooltip, $
*GRAPH_SCRIPT

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

*END
ENDSTYLE
END

-RUN




WebFOCUS 8206, Unix, Windows