Graph is splitted
Graph is splitted
(OP)
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
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
RE: Graph is splitted
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.
RE: Graph is splitted
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
RE: Graph is splitted
H/VBRSTK1
ozi