Hopefully this is an easy one for someone. I have a graph that currently contains 1 line for a rolling-12 month trend. I need to add a 2nd line for the previous rolling 12-months. I tried adding defines to identify the begin and end dates for the previous rolling 12, but then got stuck on what to do next.

Thank you!!

Here is the current code:

-INCLUDE app/cust_dash_defines_fy2013.fex
-SET &MEASR3 = IF &MEASURE EQ 'UNITS' THEN 'DASHBOARD.SEG01.NET_UNITS/D10C' ELSE IF &MEASURE EQ 'PURCHASES' THEN 'DASHBOARD.SEG01.NET_PURCHASES/P14CM' ELSE 'DASHBOARD.SEG01.GP_DOLLARS/P14CM' ;

GRAPH FILE DASHBOARD
-* Created by Advanced Graph Assistant
SUM &MEASR3 AS ''
BY DASHBOARD.SEG01.YR_MO
WHERE SHIP2REP EQ '&SALESREP.(FIND SHIP2REP IN DASHBOARD).Sales Rep.';
WHERE DASHBOARD.SEG01.CUST_NAME EQ '&CUSTOMER.(FIND CUST_NAME IN CUSTNAME).Customer-Bill To.';
WHERE DASHBOARD.SEG01.SHIP2NAME EQ '&SHIPTO.(FIND SHIP2NAME IN SHIP2NAME).Ship to.' OR (SELL_ALL_ST EQ 'Y');
WHERE ( DASHBOARD.SEG01.YR_MO GT 12MNTH_YRMO ) AND ( DASHBOARD.SEG01.YR_MO LE TODAY_YRMO );
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/Hercules.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setDepthRadius(0);
setUseSeriesShapes(true);
setMarkerSizeDefault(50);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setFontName(getO1Label(),"Times New Roman");
setFontSizeAbsolute(getO1Label(), true);
setFontSizeInPoints(getO1Label(), 7);
setPlaceResize(getO1Label(), 0);
setDepthRadius(0);
setDepthAngle(0);
setTextString(getO1Title(),"");
setFillColor(getChartBackground(),new Color(210,180,140));
setMarkerSize(getSeries(0),50);
setLineWidth(getSeries(0),3);
setLineBasicStrokeType(getSeries(0),0);
setDisplay(getY1MajorGridColorBand1(),true);
setFillColor(getY1MajorGridColorBand1(),new Color(221,221,221));
setDisplay(getY1MajorTick(),true);setTickStyle(getY1MajorTick(),3);
ENDSTYLE
END
-IF &RECORDS GT 0 THEN GOTO GPHPAS3;
-HTMLFORM NO_DATA
-GPHPAS3
-EXIT  

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

its just as simple as putting another field in your sum statement.

So something like

SUM &MEASR3 AS '1st measure'
    &MEASR2 AS '2nd measure'
BY DASHBOARD.SEG01.YR_MO
  

Hi Eric,

Thank you for the reply. I'm not sure I follow though. I'm summing the same measurement, just different date ranges. Months 1-12, then months 13-24. Will this still work?

I think you will need to do some preprocessing before doing the graph.