With sales being the amount of sales for that month and year.
I want the Month to be the x axis and sales to be the Y with each year being its seperate series.
There doesn't seem to be way to do this through the GUI. I'm thinking I can probably alter the hold file to accomodate what I need but wanted to see if anyone has solved for this issue.This message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8 Windows, All Outputs
April 07, 2017, 12:19 PM
BM
hi, Here is how it can be done. Assuming both Month and Year are Integers, Have 2 define fields:
Thanks for the tip but that doesn't seem to be having the desired effect. That is just extending it out for the entire timeframe.
What is being required is the x axis will be a static Jan,Feb,Mar,Apr,May,June,July....Dec
Then I will be pulling back 4 years of data and plotting a line graph. What I need is for 2014 to be a line, 2015 to be a seperate line, 2016 to be a line, and 2017 with all four lines plotting there values for each month. Does that make sense?
WebFOCUS 8 Windows, All Outputs
April 10, 2017, 09:11 AM
RayP
In the GUI: Sales would be the Measure Month on the X Axis Year would be in the Legend(Series) section.
Webfocus v8.2.02 OS:Windows 10, DB2, SQL Output: HTML, PDF and Excel