Focal Point
[Solved] Stacking graphs in BI

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

January 25, 2012, 02:46 PM
paulI
[Solved] Stacking graphs in BI
Greetings. I am trying to write a dashboard with 4 graphs. Currently I have them side by side but would like to have it in a 2 up (stacked) format. One post I read said the height of a BI column was not changable. But another post (What things are people putting on their dashboard, Apr 26, 2007) shows an example posted by Francis showing the format I was looking for. Can someone give me advice on how this was done. Thank you all in advance.
Paul

This message has been edited. Last edited by: paulI,


Prod: WF 7.7.05, BID, MRE, 7.7.06M Server, Windows 2008, RedHat, Oracle 11gR1, MS Office 2010
Test: I wish we had one!
January 30, 2012, 11:54 AM
Todd_Wallace
It can be done in Info Assist by using the type of file Document instead of report or chart. I have included the sample code below to show how graphs can be 2 X 2 in the compound format. Hope that helps.
  COMPOUND LAYOUT PCHOLD FORMAT PDF
SECTION=Section_1, LAYOUT=ON, PAGESIZE=LETTER, ORIENTATION=PORTRAIT, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.25, BOTTOMMARGIN=0.25, $
COMPONENT=Chart_1, COMPONENT-TYPE=GRAPH, POSITION=(0.708333 0.947916), DIMENSION=(3.385416 2.34375), METADATA='VERSION:1.0', $
COMPONENT=Chart_2, COMPONENT-TYPE=GRAPH, POSITION=(4.625 0.979166), DIMENSION=(3.385416 2.34375), METADATA='VERSION:1.0', $
COMPONENT=Chart_3, COMPONENT-TYPE=GRAPH, POSITION=(0.614583 4.708333), DIMENSION=(3.385416 2.34375), METADATA='VERSION:1.0', $
COMPONENT=Chart_4, COMPONENT-TYPE=GRAPH, POSITION=(4.572916 4.65625), DIMENSION=(3.385416 2.34375), METADATA='VERSION:1.0', $
END

SET COMPONENT=Chart_1
-*component_type graph
GRAPH FILE CAR
-* Created by Info Assist for Graph
SUM CNT.CAR.CARREC.MODEL
BY CAR.COMP.CAR
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET VAXIS 2.34375
ON GRAPH SET HAXIS 3.385416
ON GRAPH SET UNITS INCHES
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *



WebFOCUS 8.1.05
Windows-iSeries DB2, All Outputs
HTML
January 31, 2012, 02:12 PM
paulI
Thanks Todd. Problem is we do not have Info Assist. Does this same technique work in dev studio/html editor?


Prod: WF 7.7.05, BID, MRE, 7.7.06M Server, Windows 2008, RedHat, Oracle 11gR1, MS Office 2010
Test: I wish we had one!
January 31, 2012, 02:48 PM
Todd_Wallace
Yes I just used IA to generate the code. It should work in Dev Studio.


WebFOCUS 8.1.05
Windows-iSeries DB2, All Outputs
HTML
February 01, 2012, 09:32 AM
paulI
Worked like a champ. Thank you Todd.


Prod: WF 7.7.05, BID, MRE, 7.7.06M Server, Windows 2008, RedHat, Oracle 11gR1, MS Office 2010
Test: I wish we had one!