I have a barchart that I created. On the chart I have added a 'goal' line of 400 and I want to add a traffic light for a condition to show that if the weekly load count was 400 or more the bar is green. If less the bar is red.

I applied a CNT function to this field I am applying the Traffic Light condition to, and when I run the report all of the bars turn green even though some do not meet the requirement. I have used the Traffic Light function numerous times without issue, so I am wondering if it is not allowed or does not function like it should after I applied the CNT function.

I am relatively new to the BI app, but have created several reports and have not run in to this yet.

I am using Version 7 Release 7.03.

Thanks,
Jeff

This message has been edited. Last edited by: JeffH,

Jeff,

Are you applying it to all data instead of just one column?

Please try and replicate the situation with the CAR or GGSALES file and post it (using [ code] and [/code] tags ) so that we can see how you are coding this.

T

I am not sure what or where the CAR or GGSALES files are, but here is the code for this chart.

I am not someone who writes code, so I want to make sure that is clear. I am a business analyst and am creating the reports and charts using the Infoassist and WebFocus tools.

Hopefully this is what you are looking for:


-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$CjxSb290IHZlcnNpb249IjEuMCIgPgogICA8T2JqZWN0IG9iamVjdElkPSJDaGFydF8xIiA+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJDcm9zc1RhYk1vZGUiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIiA+dHJ1ZTwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJMaW5rZWRTb3J0cyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgIDwvT2JqZWN0PgogICA8T2JqZWN0IG9iamVjdElkPSJHTE9CQUwiID4KICAgICAgPFByb3BlcnR5IG5hbWU9IlNhbXBsZURhdGEiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIiA+dHJ1ZTwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJHbG9iYWxSZWNvcmRMaW1pdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjEwMDwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJmaWVsZERpc3BsYXlNb2RlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+bGFiZWw8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0icHJlZml4RGlzcGxheU1vZGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID48L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iZW5hYmxlUHJldmlldyIgdHlwZT0iamF2YS5sYW5nLkJvb2xlYW4iID50cnVlPC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9IkxpbmtlZFNvcnRzIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+PC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9IkZleFN0YXRlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+eyZxdW90O19hckNvbXBvbmVudHMmcXVvdDs6W119PC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9IkZvY2V4ZWNQcmVmZXJlbmNlcyIgdHlwZT0iTWFwIiA+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfdGFibGVfZm9ybWF0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+SFRNTDwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlFZGl0TW9kZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUZvcm1hdFRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SG9tZVRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVF1aWNrQWNjZXNzVG9vbGJhclNhdmVJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID50cnVlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVJlc291cmNlc0ZpZWxkVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X2NoYXJ0X2Zvcm1hdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPkhUTUw8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SW5zZXJ0VGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkVkaXRJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlTZXJpZXNUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImluZm9Bc3Npc3RNb2RlQWxsb3dlZEluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF9wcmV2aWV3X3BhZ2VsaW1pdF9sYXlvdXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID4xPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZXhjZWxfZm9ybWF0X3Zpc2libGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID50cnVlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF9wcmV2aWV3X3BhZ2VsaW1pdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X2NvbXBvc2VfZm9ybWF0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+UERGPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUludGVyYWN0aXZlTW9kZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5RGF0YVRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZWRpdG9yVHlwZV92aXNpYmxlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9InRoZW1lc19jb250cm9sX3Zpc2libGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID50cnVlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNsaWNlcnNUYWJJbnRlcmFjdGl2ZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5TGF5b3V0VGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICA8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iY2FzY2FkZU5hbWVzIiB0eXBlPSJNYXAiID48L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iTWFzdGVy
*-INTERNAL_COMMENT LINE#1$X0ZpbGVzIiB0eXBlPSJTZXQiID4KICAgICAgICAgPEVudHJ5IHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5MT0FEX1BFUkZPUk1BTkNFPC9FbnRyeT4KICAgICAgPC9Qcm9wZXJ0eT4KICAgPC9PYmplY3Q+CjwvUm9vdD4=
-*Do not delete or modify the comments above

-*COMPONENT=Define_LOAD_PERFORMANCE
DEFINE FILE LOAD_PERFORMANCE
TenderMonth/MYY=HDATE ( LOAD_PERFORMANCE.INDEX_FIELDS.LPC_TENDER_DATE , 'YYMD' ) ;
CurrentDate/YYMD='&YYMD' ;
LastMonth/I2=HPART ( DT ( &YYMD ) , 'MONTH' , 'I2' ) - 1 ;
TenderYear/YY=HPART ( LOAD_PERFORMANCE.INDEX_FIELDS.LPC_TENDER_DATE , 'YEAR' , 'I4' ) ;
CurrentYear/I4=HPART ( DT ( &YYMD ) , 'YEAR' , 'I4' ) ;
TenderWeek/MDYY=DATEMOV ( HDATE ( LOAD_PERFORMANCE.INDEX_FIELDS.LPC_TENDER_DATE , 'YYMD' ) , 'EOW' ) ;
END
GRAPH FILE LOAD_PERFORMANCE
-* Created by Info Assist for Graph
COUNT CNT.LOAD_PERFORMANCE.PRIMARY_LOAD_FIELDS.LPC_SHIPPER_LOAD_NBR
BY TenderWeek
WHERE LOAD_PERFORMANCE.INDEX_FIELDS.LPC_TENDER_DATE GE DT('&&DTE_LAST_QUARTER_START.LAST_QUARTER_START.') AND LOAD_PERFORMANCE.INDEX_FIELDS.LPC_TENDER_DATE LE DT('&&DTE_TODAY.DTE_END.');
WHERE LOAD_PERFORMANCE.INDEX_FIELDS.LPC_TENDER_DATE GE DT(2013/01/01);
WHERE LOAD_PERFORMANCE.PRIMARY_LOAD_FIELDS.LPC_GROUP_NAME EQ '3RD PARTY';
HEADING
"Weekly Load Volume - 3PL"
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET PAGE-NUM NOLEAD
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET EMBEDHEADING ON
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *

setReportParsingErrors(false);
setSelectionEnableMove(false);
setCurveFitEquationDisplay(false);
setPieFeelerTextDisplay(1);
setPlace(true);
setDataTextDisplay(true);
setDisplay(getDataText(0),true);
setDisplay(getDataText(1),true);
setDisplay(getDataText(2),true);
setDisplay(getDataText(3),true);
setDisplay(getDataText(4),true);
setDisplay(getDataText(5),true);
setDisplay(getDataText(6),true);
setDisplay(getDataText(7),true);
setDisplay(getDataText(8),true);
setDisplay(getDataText(9),true);
setDisplay(getDataText(10),true);
setDisplay(getDataText(11),true);
setDisplay(getDataText(12),true);
setDisplay(getDataText(13),true);
setDisplay(getDataText(14),true);
setDisplay(getDataText(15),true);
setDisplay(getDataText(16),true);
setDisplay(getDataText(17),true);
setDisplay(getDataText(18),true);
setDisplay(getDataText(19),true);
setDisplay(getDataText(20),true);
setDisplay(getDataText(21),true);
setDisplay(getDataText(22),true);
setDisplay(getDataText(23),true);
setDisplay(getDataText(24),true);
setDisplay(getDataText(25),true);
setDisplay(getDataText(26),true);
setDisplay(getDataText(27),true);
setDisplay(getDataText(28),true);
setDisplay(getDataText(29),true);
setDisplay(getDataText(30),true);
setDisplay(getDataText(31),true);
setDisplay(getDataText(32),true);
setDisplay(getDataText(33),true);
setDisplay(getDataText(34),true);
setDisplay(getDataText(35),true);
setDisplay(getDataText(36),true);
setDisplay(getDataText(37),true);
setDisplay(getDataText(38),true);
setDisplay(getDataText(39),true);
setDisplay(getDataText(40),true);
setDisplay(getDataText(41),true);
setDisplay(getDataText(42),true);
setDisplay(getDataText(43),true);
setDisplay(getDataText(44),true);
setDisplay(getDataText(45),true);
setDisplay(getDataText(46),true);
setDisplay(getDataText(47),true);
setDisplay(getDataText(48),true);
setDisplay(getDataText(49),true);
setDisplay(getDataText(50),true);
setDisplay(getDataText(51),true);
setDisplay(getDataText(52),true);
setDisplay(getDataText(53),true);
setDisplay(getDataText(54),true);
setDisplay(getDataText(55),true);
setDisplay(getDataText(56),true);
setDisplay(getDataText(57),true);
setDisplay(getDataText(58),true);
setDisplay(getDataText(59),true);
setDisplay(getDataText(60),true);
setDisplay(getDataText(61),true);
setDisplay(getDataText(62),true);
setDisplay(getDataText(63),true);
setSeriesType(2,0);
setTextRotation(getO1Label(),3);
setFontName(getO1Label(),"SansSerif");
setFontSizeAbsolute(getO1Label(),true);
setFontSizeInPoints(getO1Label(),10);
setPlaceResize(getO1Label(),0);
setFontStyle(getO1Label(),0);
setTextJustHoriz(getO1Label(),2);
setFillColor(getO1Label(),new Color(66,70,73));
setCurveFitType(0,2);
setCurveFitType(1,2);
setCurveFitType(2,2);
setDisplay(getLegendArea(),false);
setColorMode(1);
setPieTilt(0);
setPieDepth(0);
setDepthRadius(0);
setDepthAngle(0);
setReferenceTextPosition(getReferenceLineTextY1(0),0);
setDisplay(getReferenceLineY1(0),true);
setBorderColor(getReferenceLineY1(0),new Color(255,128,0));
setFillColor(getReferenceLineTextY1(0),new Color(255,128,0));
setReferenceLineValueY1(0,400.0);
setLineWidth(getReferenceLineY1(0),3);
setLineBasicStrokeType(getReferenceLineY1(0),16);
setTextString(getReferenceLineTextY1(0),"GOAL");
setDisplay(getReferenceLineTextY1(0),true);
ENDSTYLE
ON GRAPH SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
DEFMACRO=Condition_1, COLOR=RGB(0 255 0), WHEN=N2 GE '400', $
DEFMACRO=Condition_2, COLOR=RGB(255 0 0), WHEN=N2 LT '400', $
TYPE=REPORT, ORIENTATION=LANDSCAPE, $
TYPE=TABHEADING, JUSTIFY=CENTER, FONT='Trebuchet MS', SIZE=14, COLOR=RGB(66 70 73), STYLE=BOLD+ITALIC, $
TYPE=TABHEADING, LINE=1, JUSTIFY=CENTER, $
TYPE=TABHEADING, LINE=2, JUSTIFY=CENTER, $
TYPE=HEADING, JUSTIFY=LEFT, FONT='Trebuchet MS', SIZE=10, COLOR=RGB(66 70 73), STYLE=BOLD, $
TYPE=DATA, COLUMN=N2, MACRO=Condition_1, $
TYPE=DATA, COLUMN=N2, MACRO=Condition_2, $
ENDSTYLE
END

-RUN

{status:'SUCCESS',hasstatus:true,exception:[]}