I can not display the graph, problems with the formatting.

This is one of the code for the graph:


-******************
TABLE FILE USER_DATA

PRINT OS_USERNAME
LOGIN_DAY
-*

BY LOGIN_YEAR
BY LOGIN_MONTH

ON TABLE HOLD AS USR_COUNTS FORMAT ALPHA
END

GRAPH FILE USR_COUNTS
SUM OS_USERNAME AS 'User'
BY USERNAME AS 'User Names'
ACROSS LOGIN_DAY
ON GRAPH SET STYLE *
SQUEEZE=ON,
TYPE=REPORT, FONT=BOLD, JUSTIFY=CENTER,
$
ENDSTYLE
END
-******************

I get the following output for all the ouput graphs any thoughts?

0 NUMBER OF RECORDS IN TABLE= 246463 LINES= 5061
(BEFORE DISTINCT TESTS)
0 NUMBER OF RECORDS IN TABLE= 288 LINES= 288
0 NUMBER OF RECORDS IN GRAPH= 288 PLOT POINTS= 12
VERTICAL AXIS IS NOT NUMERIC..CAN'T GRAPH

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

Do you want to do a COUNT instead of a SUM?

As Ginny suggests the Y axis must always be numeric

So SUM OS_USERNAME AS 'User' is not valid
but SUM CNT.OS_USERNAME AS 'User' is

Yes!! Thanks!! The SUM CNT.USERNAME works....Now, when I select a given month rather than the "All" option....it does not display. Could it be the same issue?

I also fixed the Month issue, needed to have the LOGIN_DAY added into the first table hold....Thanks Again!