I'm using WebFOCUS 5.21 on Windows NT.
I have a graph that has an across by month. The problem is the month is a number and I need the 3 character abbreviation to show on the display. For 01, I want Jan, 02 Feb, etc. Here's part of my define.
MYMONTH/A3=DECODE MYMONTHI(1 'JAN' 2 'FEB' 3 'MAR' 4 'APR' 5 'MAY' 6 'JUN' 7 'JUL' 8 'AUG' 9 'SEP' 10 'OCT' 11 'NOV' 12 'DEC');
The graph statement is ACROSS MYMONTH which makes the sort on the alphanumeric month instead of the numeric month. Naturally I want the order to be Jan, Feb, Mar, etc.
Is there a way to sort it by the numeric month but display the alphanumeric representation?
You can use 'COLUMNS'
Using your DEFINES
COLUMNS JAN AND FEB AND MAR AND APR ....
Thanks, it worked like a charm. Hadn't heard of COLUMNS, but then I'm pretty new at building graphs.
Why don't you just change MYMONTHI/M=MYDT to MYMONTHI/MT=MYDT. This will set the MYMONTHI field equal to the 3 character values you are manually setting in your define. See my example:
DEFINE FILE CENTORD
GRAPH FILE CENTORD
|Powered by Social Strata|