Focal Point
Changing the 100% in graph to real percentage.

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

January 16, 2006, 09:36 AM
Cyril Joy
Changing the 100% in graph to real percentage.
In the following example, how to make the percentage values to show the exact
values instead of showing as 100%?
GRAPH FILE CAR
SUM DEALER_COST RETAIL_COST
ACROSS COUNTRY
ON GRAPH SET LOOKGRAPH HBRSTKPC
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET GRID ON
ON GRAPH SET GRAPHSTYLE *
setStackedDataValueSum(true);
ENDSTYLE
END

Thanks for your help. I have WF710 studio.


Regards,
Cyril Joy.

WF Production 8008 on Linux.
January 17, 2006, 02:30 AM
Michael
I Think this is what you want.
  
GRAPH FILE CAR
SUM RPCT.CAR.BODY.DEALER_COST RPCT.CAR.BODY.RETAIL_COST
ACROSS CAR.ORIGIN.COUNTRY
ON GRAPH SET LOOKGRAPH HBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D OFF
ON GRAPH SET GRID ON
ON GRAPH SET GRAPHSTYLE *
setStackedDataValueSum(true);
ENDSTYLE
END


January 17, 2006, 03:29 AM
Tony A
Hi Cyril,

If you want horizontal stacked bars with values instead of percentages then use graphtype 25 -

setGraphType(25);


Tony



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 
January 17, 2006, 06:17 AM
Cyril Joy
Actually I want the value to be displayed only as percentage.

For example, in the example, the first bar is showing 46% and 100%.
Instead of that I want the display as 46% and 54%.

Any clues?


Regards,
Cyril Joy.

WF Production 8008 on Linux.
January 17, 2006, 11:12 AM
Tony A
Cyril,

I don't think you can do that with a horizontal stacked percentage as, by it's very nature, it always accumulates the bar values for display.

However, you can always manipulate your data to give what you want -

GRAPH FILE CAR
  SUM COMPUTE TOTAL_COST/D12.2 = DEALER_COST + RETAIL_COST; NOPRINT
      COMPUTE DCOST_PCT/D7.2% = SUM.DCOST / SUM.TOTAL_COST * 100;
      COMPUTE RCOST_PCT/D7.2% = SUM.RCOST / SUM.TOTAL_COST * 100;
ACROSS COUNTRY 
ON GRAPH SET GRAPHEDIT SERVER 
ON GRAPH SET BARNUMB ON 
ON GRAPH SET 3D OFF 
ON GRAPH SET VZERO OFF 
ON GRAPH SET GRID ON 
ON GRAPH SET GRAPHSTYLE * 
setGraphType(25);
setStackedDataValueSum(false);
ENDSTYLE 
END

Just needs a tweek on the scale min and max plus the data label format etc.

Enjoy

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