I have created a bar chart which will show two bars for 201611 and 201612 on the x axis and revenue on the y-axis.Revenue for 201611 is $26,748,368.64 and for 201612 $ 27,710,991.14. These two bar charts are blue in color.
1)Is it possible to keep the 201612 in blue color, but the part of the bar where it exceeds the 201611 i.e.growth($ 27,710,991.14-$26,748,368.64=962622.5) in green color? 2)A horizontal line from y-axis label to 201612 bar to show the point from where the growth started. I have pasted my code below, Please provide your inputs if you have a way to do this.
ENGINE INT CACHE SET ON
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE wf_retail_lite
WHERE WF_RETAIL_LITE.WF_RETAIL_TIME_SALES.TIME_YEARMTH GE 201611;
WHERE WF_RETAIL_LITE.WF_RETAIL_TIME_SALES.TIME_YEARMTH LE 201612;
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N2, BUCKET=y-axis, $
Regards BI DevThis message has been edited. Last edited by: FP Mod Chuck,
Webfocus 8105/8202 Windows All Outputs
September 03, 2020, 04:17 PM
FP Mod Chuck
There is no way out of the box to do number 1 you can't split the color of a bar based on comparing values between them. For number 2 I was thinking a reference line but when I tried that with your example the reference line went across the highest value for the revenue field and otherwise you would need to hard code a value which isn't what you want. So I am sorry to have to tell you that I don't think it is possible but I have been wrong before. Maybe someone else has a way. Maybe a D3 option but I am not real savvy with those.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
September 04, 2020, 11:15 AM
Yes, I could not do that out of the box so far, checking to see if somebody else has done something similar. Thanks.