Hi Everyone,

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
SET PAGE-NUM=NOLEAD
-DEFAULTH &WF_HTMLENCODE=OFF;
SET HTMLENCODE=&WF_HTMLENCODE

SET ARGRAPHENGINE=JSCHART
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT

SET EMBEDHEADING=ON
SET GRAPHDEFAULT=OFF
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';

-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE wf_retail_lite

SUM WF_RETAIL_LITE.WF_RETAIL_SALES.REVENUE_US
BY WF_RETAIL_LITE.WF_RETAIL_TIME_SALES.TIME_YEARMTH
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 *
*GRAPH_SCRIPT

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);

*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N2, BUCKET=y-axis, $
*GRAPH_SCRIPT

setReportParsingErrors(false);
setSelectionEnableMove(false);

*END
ENDSTYLE
END

-RUN


 

Regards
BI Dev

This message has been edited. Last edited by: FP Mod Chuck,

BI Dev

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.

Hi Chuck,

Yes, I could not do that out of the box so far, checking to see if somebody else has done something similar. Thanks.

Best regards

BI DEV