Hi,

I need the date value along the X axis to be displayes as Mondd, when Mon is the 3 digit month and dd is the date from 01 to 30/31.
Please let me know how I can accomplish this
Thanks

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

you can define a new field based on the datefield.

something like this

DEFINE FILE OPT_M_HI
MAAND/Mt=PRE_WRKDAG;
END
GRAPH FILE OPT_M_HI
SUM CNT.SOM_BRUTO 
ACROSS MAAND 
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
...

This will display only the 3 character month. I also need the day of the month to be appended to this month.


SQL SQLORA

SELECT
START_WEEK,
'PHASE'||PHASE AS PHASE,
COUNT(DISTINCT IBD_NUM) AS IBD_NUM
FROM PROD_LOGINS_WEEKLY_TEMP
WHERE USER_CATEGORY IN('Pure 360','Mixed 360') AND PHASE<>0 AND GROUP_FLD IN('DBS','GSS','NC')
AND START_WEEK BETWEEN (TRUNC(SYSDATE,'DAY')+1)-70 AND ((TRUNC(SYSDATE,'DAY')+1)-7)+ 6
GROUP BY START_WEEK,
PHASE
ORDER BY PHASE;

SQL SQLORA END SESSION;

TABLE FILE SQLOUT
PRINT
*
AND
COMPUTE TRANSDATE/YYMD = HDATE(START_WEEK, 'YYMD');
TIMELINE/MDY=TRANSDATE;
AND COMPUTE START_WEEK1/Mt=TRANSDATE;
START_WEEK_D/D=TRANSDATE;
-*********** I am not able to concatenate month and date as I tried to do in the below line which throws error ****----
COMPUTE MONTH_DAY = START_WEEK1||START_WEEK_D;
ON TABLE HOLD AS H1
END


TABLE FILE H1
PRINT *
END

Thanks

This might work:

TRANSDATE2/A11 = DATETRAN(TRANSDATE,'(YYMD)','(t)','EN',11,'A11');
TRANSDATE3/A5  = EDIT(TRANSDATE2,'$$$$$999$99');

Hi,

Thanks for the response. I was able to reproduce the same using the below command:

COMPUTE TIMELINE/A7=EDIT(CHGDAT('YMD', 'MTYY', EDIT(TIMELINE1), 'A17'),'9999,$$99');
COMPUTE TIMELINE_D/A7=EDIT(CHGDAT('YMD', 'MTD', EDIT(TIMELINE1), 'A17'),'9999,99');

But in both the cases, we are converting it to alpha numeric format. Hence while displaying the date in the X axis in graph, it gets sorted alphabetically. Hence Feb comes before Jan.
Please let me know if there is any option to convert this to date again so as to display as date along graph's X Axis.

Thanks

Can you sort by TIMELINE1 first with NOPRINT?

GRAPH FILE <filename>
SUM ....
BY TIMELINE1 NOPRINT
BY TIMELINE
.
.
.
END

Two byfields will not work in a graph

Is it acceptable if the year is visible ?

if that is no problem you can say

MAAND/YMtD =PRE_WRKDAG;

try to use smartdates....

did you take a look in the manual for graphics?

how many days do you expect in your graph?
if it is more then 20, it will be difficult to read the days.

Hi,

The user needs the data only in that format.
Even if use BY field with NOPRINT, the BY field is also appearing the legend which is not desirable..

You might try this. Since START_WEEK already appears to be in a date-time format of HYYMDS, simply convert it to a date-time format of HMtD ("Mon DD"). Hopefully, this date-time field will sort properly in the graph.

TIMELINE/HMtD = START_WEEK ;

Yes, this works fine, Thanks..