Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Graph with month as across field
Go
New
Search
Notify
Tools
Reply
  
Graph with month as across field
 Login/Join
 
Silver Member
posted
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.

MYDT/MDYY=DATE;
MYMONTHI/M=MYDT;
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?

Thanks,
Raelene
 
Posts: 31 | Location: Oklahoma City, OK | Registered: September 11, 2003Reply With QuoteReport This Post
Platinum Member
posted Hide Post
You can use 'COLUMNS'

Using your DEFINES

ACROSS MYMONTH
COLUMNS JAN AND FEB AND MAR AND APR ....
 
Posts: 105 | Location: Boston | Registered: April 23, 2003Reply With QuoteReport This Post
Silver Member
posted Hide Post
Thanks, it worked like a charm. Hadn't heard of COLUMNS, but then I'm pretty new at building graphs.

Thanks again.
 
Posts: 31 | Location: Oklahoma City, OK | Registered: September 11, 2003Reply With QuoteReport This Post
<Kyle>
posted
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:

SET LOOKGRAPH=LINE
DEFINE FILE CENTORD
3MONTH/Mt=ORDER_DATE;
END
GRAPH FILE CENTORD
SUM LINEPRICE
ACROSS 3MONTH
END
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Graph with month as across field

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.