TABLE FILE DISCOUNTS
SUM
DISCOUNTS.DISCOUNTS.DiscountCount
-*BY HIGHEST 5
MAX.DISCOUNTS.DISCOUNTS.DiscountCount
BY DISCOUNTS.DISCOUNTS.BusinessDate
WHERE DISCOUNTS.SITECONCEPT.SiteConceptNumber EQ &Concept_No;
WHERE DISCOUNTS.LOCATION.LocationID IN (&Location);
WHERE DISCOUNTS.DISCOUNT.DepartmentID IN (&Dept_ID);
WHERE DISCOUNTS.DISCOUNT.DiscountID IN (&Discount_ID);
WHERE (DISCOUNTS.DISCOUNTS.BusinessDate GE '&Start_Date') AND (DISCOUNTS.DISCOUNTS.BusinessDate LE '&End_Date');
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS DISC FORMAT ALPHA
END
-RUN

?FF DISC

JOIN INNER ROLLING_DATES.ROLLING_.BusinessDate IN ROLLING_DATES TO MULTIPLE DISC.DISC.BusinessDate IN DISC TAG J0 AS J0
END

GRAPH FILE ROLLING_DATES
SUM
J0.DISC.E02 AS 'Discount Type Counts'
BY ROLLING_DATES.ROLLING_.GroupBy AS 'Date';
BY HIGHEST 5 DIS.DIS.RNK.DiscountCount
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET EMBEDHEADING ON
ON GRAPH SET HAXIS 770.0
ON GRAPH SET VAXIS 405.0
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
*END
INCLUDE=IBFS:/WFC/Repository/Styles_and_Images/RosnetRpt.sty,$
-*TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
*GRAPH_SCRIPT
setDisplay(getX1Title(),false);
setDisplay(getY1Title(),true);
setReportParsingErrors(false);
setSelectionEnableMove(false);
setLineStyleLegendMarkers(2);
setTextRotation(getY1Label(),0);
setTextRotation(getO1Label(),3);
setLabelStagger(getO1Label(),true);
setDisplay(getDataText(0), true);
setDataTextDisplay(false);
setTransparentBorderColor(getChartBackground(),true);
*END
ENDSTYLE
END
-RUN

I have used highest 5 and max operators but the graph is not being displayed

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

Hi Nihitha

Welcome to Focal Point. It is a great forum for WebFOCUS developers...

Try changing the order of your JOIN and make it a UNIQUE join as below


JOIN INNER DISC.DISC.BusinessDate IN DISC TO UNIQUE ROLLING_DATES.ROLLING_.BusinessDate IN ROLLING_DATES TAG J0 AS J0
END

GRAPH FILE DISC