Graph is splitted

[ozi2]

Hi all,
I created a graph using the following code:
SET LOOKGRAPH = STACK
SET GRAPHEDIT = OFF
-*SET GRID=ON SET BARNUM =OFF
SET 3D = OFF

GRAPH FILE V_ID_INV_AGG_EZORSHOTFUT_GRAPH

SUM
ITYASVUT SHIKUM
SHUTFUT KRANOT
ACROSS
ACTIONTYPEINYEAR AS ''

WHERE (YEARCODE EQ &PREVYEAR OR YEARCODE EQ &TOYR)
AND ( EZORSHOTFUTCODE EQ '&EZOR')
AND ( CURRENCY EQ &CURR );
END

The values I get are ok but the graph does not
stack all 4 meassures on one stack for each
ACTIONTYPEINYEAR.
Instead it stack only first 3 meassures and
the forth (KRANOT) is displayed above them
with a different Y axis and with a horizontal line
between them. They have the same legend also.
(It seems like 2 graphs with the same x axis
one above the other).

Any idea what can cause this?
10'x,
OZI

 

[WFGuru]

Ozi,

This will occur when you have a large difference of values between some of measures. If the java interface that creates the graphs were to plot them all the same, you would see some very small bars next to some very large bars. So, the interface decides to split the graph to make it easier to read. I don't know if there is an API command to control that but you may want to consider creating separate graphs.

 

[ozi2]

Hi WFGuru,
I also thought this at the beginning BUT I'm not 100% sure about this.
I have another meassure (SHIKUM),
which also has small values and it appears with
the other 2 meassures. I discluded SHIKUM from the
command and still KRANOT appers by it own.

Thanks anyway,
OZI

 

[ozi2]

I succeded to pass around it by selecting a different type of chart:
H/VBRSTK1

ozi