Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Graph is splitted

Status
Not open for further replies.
ozi2

ozi2

Programmer
Sep 1, 2002
40
IL
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
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
I succeded to pass around it by selecting a different type of chart:
H/VBRSTK1

ozi
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ekl0908
  • Locked
  • Question
Is there a maximum length for an index field?
Replies
0
Views
300
ekl0908
ekl0908
jackiev
  • Locked
  • Question
Who is running the report - USERNAME
Replies
2
Views
238
gizzy17
gizzy17
LeonelSanchezJr
  • Locked
  • Question
Custom Graph Colors
Replies
1
Views
187
focusdev
focusdev
goofy2320
  • Locked
  • Question
ALL option in HTML is not returning correct data.
Replies
1
Views
214
goofy2320
goofy2320
sagobogger
  • Locked
  • Question
EXL2K saves as .XLS but format is really webpage/.mht
Replies
3
Views
260
thegrinder01
thegrinder01

Part and Inventory Search

Sponsor

Back
Top