I wish to be able to create a simple line graph that shows actual, plan and last year as seperate series. X-Axis is shown as days for current month. Source is taken from a SAS dataset. The actual will be populated every day and will be compared against the plan and last year values for the month

My issue is that the actual line series dips down to zero when there are no values present. I don't want this to happen, I simply want the null values not be be displayed in the chart. The values in SAS are definately NULL, but WF seems to translate this into 0.

I have looked through the forums and seen that normally this is handled by a combination of the following

ON GRAPH SET VZERO OFF
setFillMissingData(0);
MISSING ON for measure in Master

None of these works as the line still dips to zero.

Please can you see if there is something missing in my code?

Below is my code
-* File exec_total_new_business_chart.fex
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$CjxSb290IHZlcnNpb249IjEuMCIgPgogICA8T2JqZWN0IG9iamVjdElkPSJHTE9CQUwiID4KICAgICAgPFByb3BlcnR5IG5hbWU9IlNhbXBsZURhdGEiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIiA+ZmFsc2U8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID41MDA8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUnVuUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID4wPC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9ImZpZWxkRGlzcGxheU1vZGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5sYWJlbDwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJwcmVmaXhEaXNwbGF5TW9kZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJlbmFibGVQcmV2aWV3IiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiIgPnRydWU8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iRm9jZXhlY1ByZWZlcmVuY2VzIiB0eXBlPSJNYXAiID4KICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF90YWJsZV9mb3JtYXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5IVE1MPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUVkaXRNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5Rm9ybWF0VGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlIb21lVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5UXVpY2tBY2Nlc3NUb29sYmFyU2F2ZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5UmVzb3VyY2VzRmllbGRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfY2hhcnRfZm9ybWF0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+SFRNTDwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlJbnNlcnRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlTbGljZXJzVGFiRWRpdEluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNlcmllc1RhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iaW5mb0Fzc2lzdE1vZGVBbGxvd2VkSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X3ByZXZpZXdfcGFnZWxpbWl0X2xheW91dCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjE8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJleGNlbF9mb3JtYXRfdmlzaWJsZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X3ByZXZpZXdfcGFnZWxpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+NTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfY29tcG9zZV9mb3JtYXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5QREY8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SW50ZXJhY3RpdmVNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlEYXRhVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJlZGl0b3JUeXBlX3Zpc2libGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID50cnVlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0idGhlbWVzX2NvbnRyb2xfdmlzaWJsZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkludGVyYWN0aXZlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlMYXlvdXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgIDwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJjYXNjYWRlTmFtZXMiIHR5cGU9Ik1hcCIgPjwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJNYXN0ZXJfRmlsZXMiIHR5cGU9IlNldCIgPgogICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPkVYRUNNSTwvRW50cnk+CiAgICAgIDwvUHJvcGVydHk+CiAgIDwvT2JqZWN0Pgo8L1Jvb3Q+
-*Do not delete or modify the comments above
GRAPH FILE EXECMI
-* Created by Advanced Graph Assistant
SUM COMPUTE JNLYNRR; AS 'Last Year'
COMPUTE JNPLNRR; AS 'Plan'
COMPUTE JNANRR; AS 'Actual'
BY EXECMI.EXECMI.REPORT_MONTH
BY EXECMI.EXECMI.REPORT_DAY
WHERE EXECMI.EXECMI.BUSINESS_UNIT EQ 'JN';
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 2
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBIRIACharcoal.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);
setMarkerShape(getAllSeries(),0);
setAutoSkip(getO1Label(),0);
setTextString(getO1Title(),"");
setMajorGridDrawEveryCount(getO1MajorGrid(),1);
setRiserBarGroupSpacing(1);
setTextRotation(getDataText(),0);
setLegendPosition(2);
setFillColor(getSeries(2),new Color(151,184,83));
setFillColor(getSeries(0),new Color(190,75,71));
setFillColor(getSeries(1),new Color(73,126,187));
setFillMissingData(0);
setTextFormatPattern(getY1Label(),"#.#");
setTextFormatPreset(getY1Label(),28);
setTextString(getTitle(),"Daily NRR%");
setDisplay(getTitle(),true);
ENDSTYLE
ON GRAPH SET STYLE *
TYPE=HEADING, LINE=1, ITEM=1, OBJECT=TEXT, SIZE=12, STYLE=NORMAL, $
ENDSTYLE
END


The master is set up as follows
FILENAME=execmi, SUFFIX=SQLJDBC ,
REMARKS='Exec MI', $
SEGMENT=EXECMI, SEGTYPE=S0,
DESCRIPTION='Exec MI', $
FIELDNAME=REPORT_DATE, ALIAS=date, USAGE=YYMD, ACTUAL=DATE,
MISSING=ON,
TITLE='Date',
WITHIN=REPORT_WEEK, $
FIELDNAME=REPORT_DAY, ALIAS=date, USAGE=D, ACTUAL=DATE,
MISSING=ON,
TITLE='Day',
WITHIN=REPORT_DATE, $
FIELDNAME=REPORT_YEAR, ALIAS=year, USAGE=YY, ACTUAL=D8,
MISSING=ON,
TITLE='Year',
WITHIN='*EXECMI', $
FIELDNAME=REPORT_MONTH, ALIAS=month, USAGE=Mtr, ACTUAL=D8,
MISSING=ON,
TITLE='Month',
WITHIN=REPORT_YEAR, $
FIELDNAME=REPORT_MONTH_SHORT, ALIAS=month, USAGE=Mt, ACTUAL=I4,
MISSING=ON,
TITLE='Month',
WITHIN=REPORT_MONTH, $
FIELDNAME=REPORT_MONTH_NUMBER, ALIAS=month, USAGE=M, ACTUAL=I4,
MISSING=ON,
TITLE='Month',
WITHIN=REPORT_MONTH_SHORT, $
FIELDNAME=REPORT_WEEK, ALIAS=week, USAGE=I11, ACTUAL=D8,
MISSING=ON,
TITLE='Week',
WITHIN=REPORT_MONTH_NUMBER, $
FIELDNAME=SHORTDATE, ALIAS=shortdate, USAGE=A5V, ACTUAL=A5V, $
FIELDNAME=BUSINESS_UNIT, ALIAS=Business_Unit, USAGE=A5V, ACTUAL=A5V,
TITLE='Business Unit', $
FIELDNAME=FLANB, ALIAS=FLanb, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Frontline Actual New Business', MEASURE_GROUP=MEASGRP_FL,
PROPERTY=MEASURE, $
FIELDNAME=FLPLNB, ALIAS=FLplnb, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Frontline Plan New Business', MEASURE_GROUP=MEASGRP_FL,
PROPERTY=MEASURE, $
FIELDNAME=FLLYNB, ALIAS=FLlynb, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Frontline Last Year New Business', MEASURE_GROUP=MEASGRP_FL,
PROPERTY=MEASURE, $
FIELDNAME=FLLYRO, ALIAS=FLlyro, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Frontline Last Year Renewal Offers', MEASURE_GROUP=MEASGRP_FL,
PROPERTY=MEASURE, $
FIELDNAME=FLLYRA, ALIAS=FLlyra, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Frontline Last Year Renewal Accepts', MEASURE_GROUP=MEASGRP_FL,
PROPERTY=MEASURE, $
FIELDNAME=FLPLRO, ALIAS=FLplro, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Frontline Plan Renewal Offer', MEASURE_GROUP=MEASGRP_FL,
PROPERTY=MEASURE, $
FIELDNAME=FLPLRA, ALIAS=FLplra, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Frontline Plan Renewal Accepts', MEASURE_GROUP=MEASGRP_FL,
PROPERTY=MEASURE, $
FIELDNAME=FLARO, ALIAS=FLaro, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Frontline Actual Renewal Offers', MEASURE_GROUP=MEASGRP_FL,
PROPERTY=MEASURE, $
FIELDNAME=FLARA, ALIAS=FLara, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Frontline Actual Renewal Accepts', MEASURE_GROUP=MEASGRP_FL,
PROPERTY=MEASURE, $
FIELDNAME=JNANB, ALIAS=JNanb, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Junction Actual New Business', MEASURE_GROUP=MEASGRP_JN,
PROPERTY=MEASURE, $
FIELDNAME=JNPLNB, ALIAS=JNplnb, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Junction Plan New Business', MEASURE_GROUP=MEASGRP_JN,
PROPERTY=MEASURE, $
FIELDNAME=JNLYNB, ALIAS=JNlynb, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Junction Last Year New Business', MEASURE_GROUP=MEASGRP_JN,
PROPERTY=MEASURE, $
FIELDNAME=JNLYRO, ALIAS=JNlyro, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Junction Last Year Renewal Offers', MEASURE_GROUP=MEASGRP_JN,
PROPERTY=MEASURE, $
FIELDNAME=JNLYRA, ALIAS=JNlyra, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Junction Last Year Renewal Accepts', MEASURE_GROUP=MEASGRP_JN,
PROPERTY=MEASURE, $
FIELDNAME=JNPLRO, ALIAS=JNplro, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Junction Plan Renewal Offers', MEASURE_GROUP=MEASGRP_JN,
PROPERTY=MEASURE, $
FIELDNAME=JNPLRA, ALIAS=JNplra, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Junction Plan Renewal Accepts', MEASURE_GROUP=MEASGRP_JN,
PROPERTY=MEASURE, $
FIELDNAME=JNARO, ALIAS=JNaro, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Junction Actual Renewal Offers', MEASURE_GROUP=MEASGRP_JN,
PROPERTY=MEASURE, $
FIELDNAME=JNARA, ALIAS=JNara, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Junction Actual Renewal Accepts', MEASURE_GROUP=MEASGRP_JN,
PROPERTY=MEASURE, $
FIELDNAME=BTANB, ALIAS=BTanb, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Bennetts Actual New Business', MEASURE_GROUP=MEASGRP_BN,
PROPERTY=MEASURE, $
FIELDNAME=BTPLNB, ALIAS=BTplnb, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Bennetts Plan New Business', MEASURE_GROUP=MEASGRP_BN,
PROPERTY=MEASURE, $
FIELDNAME=BTLYNB, ALIAS=BTlynb, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Bennetts Last Year New Business', MEASURE_GROUP=MEASGRP_BN,
PROPERTY=MEASURE, $
FIELDNAME=BTLYRO, ALIAS=BTlyro, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Bennetts Last Year Renewal Offers', MEASURE_GROUP=MEASGRP_BN,
PROPERTY=MEASURE, $
FIELDNAME=BTLYRA, ALIAS=BTlyra, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Bennetts Last Year Renewal Accepts', MEASURE_GROUP=MEASGRP_BN,
PROPERTY=MEASURE, $
FIELDNAME=BTPLRO, ALIAS=BTplro, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Bennetts Plan Renewal Offers', MEASURE_GROUP=MEASGRP_BN,
PROPERTY=MEASURE, $
FIELDNAME=BTPLRA, ALIAS=BTplra, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Bennetts Plan Renewal Accepts', MEASURE_GROUP=MEASGRP_BN,
PROPERTY=MEASURE, $
FIELDNAME=BTARO, ALIAS=BTaro, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Bennetts Actual Renewal Offers', MEASURE_GROUP=MEASGRP_BN,
PROPERTY=MEASURE, $
FIELDNAME=BTARA, ALIAS=BTara, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Bennetts Actual Renewal Accepts', MEASURE_GROUP=MEASGRP_BN,
PROPERTY=MEASURE, $
FIELDNAME=IBANB, ALIAS=IBanb, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='IB Actual New Business', MEASURE_GROUP=MEASGRP_IB,
PROPERTY=MEASURE, $
FIELDNAME=IBPLNB, ALIAS=IBplnb, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='IB Plan New Business', MEASURE_GROUP=MEASGRP_IB,
PROPERTY=MEASURE, $
FIELDNAME=IBLYNB, ALIAS=IBlynb, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='IB Last Year New Business', MEASURE_GROUP=MEASGRP_IB,
PROPERTY=MEASURE, $
FIELDNAME=IBLYRO, ALIAS=IBlyro, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='IB Last Year Renewal Offers', MEASURE_GROUP=MEASGRP_IB,
PROPERTY=MEASURE, $
FIELDNAME=IBLYRA, ALIAS=IBlyra, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='IB Last Year Renewal Accepts', MEASURE_GROUP=MEASGRP_IB,
PROPERTY=MEASURE, $
FIELDNAME=IBPLRO, ALIAS=IBplro, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='IB Plan Renewal Offers', MEASURE_GROUP=MEASGRP_IB,
PROPERTY=MEASURE, $
FIELDNAME=IBPLRA, ALIAS=IBplra, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='IB Plan Renewal Accepts', MEASURE_GROUP=MEASGRP_IB,
PROPERTY=MEASURE, $
FIELDNAME=IBARO, ALIAS=IBaro, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='IB Actual Renewal Offers', MEASURE_GROUP=MEASGRP_IB,
PROPERTY=MEASURE, $
FIELDNAME=IBARA, ALIAS=IBara, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='IB Actual Renewal Accepts', MEASURE_GROUP=MEASGRP_IB,
PROPERTY=MEASURE, $
FIELDNAME=FUACV, ALIAS=FUacv, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Fusion Actual Call Volumes', MEASURE_GROUP=MEASGRP_FU,
PROPERTY=MEASURE, $
FIELDNAME=FUPLCV, ALIAS=FUplcv, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Fusion Plan Call Volumes', MEASURE_GROUP=MEASGRP_FU,
PROPERTY=MEASURE, $
FIELDNAME=FULYCV, ALIAS=FUlycv, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Fusion Last Year Call Volumes', MEASURE_GROUP=MEASGRP_FU,
PROPERTY=MEASURE, $
FIELDNAME=FUTSL, ALIAS=FUtsl, USAGE=D20.2, ACTUAL=A6V,
TITLE='Fusion Target Service Level', MEASURE_GROUP=MEASGRP_FU,
PROPERTY=MEASURE, $
FIELDNAME=FUFRSL, ALIAS=FUfrsl, USAGE=D20.2, ACTUAL=A9V,
TITLE='Fusion Frontline Service Level', MEASURE_GROUP=MEASGRP_FU,
PROPERTY=MEASURE, $
FIELDNAME=FUBTSL, ALIAS=FUbtsl, USAGE=D20.2, ACTUAL=A8V,
TITLE='Fusion Bennetts Service Level', MEASURE_GROUP=MEASGRP_FU,
PROPERTY=MEASURE, $
FIELDNAME=FUJNSL, ALIAS=FUjnsl, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Fusion Junction Service Level', MEASURE_GROUP=MEASGRP_FU,
PROPERTY=MEASURE, $
FIELDNAME=FUTASA, ALIAS=FUtasa, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Fusion Target Average Speed of Answer', MEASURE_GROUP=MEASGRP_FU,
PROPERTY=MEASURE, $
FIELDNAME=FUFRASA, ALIAS=FUfrasa, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Fusion Frontline Average Speed of Answer', MEASURE_GROUP=MEASGRP_FU,
PROPERTY=MEASURE, $
FIELDNAME=FUBTASA, ALIAS=FUbtasa, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Fusion Bennetts Average Speed of Answer', MEASURE_GROUP=MEASGRP_FU,
PROPERTY=MEASURE, $
FIELDNAME=FUJNASA, ALIAS=FUjnasa, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='Fusion Junction Average Speed of Answer', MEASURE_GROUP=MEASGRP_FU,
PROPERTY=MEASURE, $
FIELDNAME=ACMACF, ALIAS=ACMacf, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='ACM Actual Claim Frequency', MEASURE_GROUP=MEASGRP_ACM,
PROPERTY=MEASURE, $
FIELDNAME=ACMPLCF, ALIAS=ACMplcf, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='ACM Plan Claim Frequency', MEASURE_GROUP=MEASGRP_ACM,
PROPERTY=MEASURE, $
FIELDNAME=ACMAUL, ALIAS=ACMaul, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='ACM Actual ULR', MEASURE_GROUP=MEASGRP_ACM,
PROPERTY=MEASURE, $
FIELDNAME=ACMPLUL, ALIAS=ACMplul, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='ACM Plan ULR', MEASURE_GROUP=MEASGRP_ACM,
PROPERTY=MEASURE, $
FIELDNAME=ACMAPI, ALIAS=ACMapi, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='ACM Actual Net PI Referral', MEASURE_GROUP=MEASGRP_ACM,
PROPERTY=MEASURE, $
FIELDNAME=ACMPLPI, ALIAS=ACMplpi, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='ACM Plan Net PI Referral', MEASURE_GROUP=MEASGRP_ACM,
PROPERTY=MEASURE, $
FIELDNAME=ACMACH, ALIAS=ACMach, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='ACM Actual Net Credit Hire', MEASURE_GROUP=MEASGRP_ACM,
PROPERTY=MEASURE, $
FIELDNAME=ACMPLCH, ALIAS=ACMplch, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='ACM Plan Net Credit Hire', MEASURE_GROUP=MEASGRP_ACM,
PROPERTY=MEASURE, $
FIELDNAME=CTMAQ, ALIAS=CTMaq, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='CTM Actual Quotes', MEASURE_GROUP=MEASGRP_CTM,
PROPERTY=MEASURE, $
FIELDNAME=CTMPLQ, ALIAS=CTMplq, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='CTM Plan Quotes', MEASURE_GROUP=MEASGRP_CTM,
PROPERTY=MEASURE, $
FIELDNAME=CTMLYQ, ALIAS=CTMlyq, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='CTM Last Year Quotes', MEASURE_GROUP=MEASGRP_CTM,
PROPERTY=MEASURE, $
FIELDNAME=CTMLYS, ALIAS=CTMlys, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='CTM Last Year Sales', MEASURE_GROUP=MEASGRP_CTM,
PROPERTY=MEASURE, $
FIELDNAME=CTMAS, ALIAS=CTMas, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='CTM Actual Sales', MEASURE_GROUP=MEASGRP_CTM,
PROPERTY=MEASURE, $
FIELDNAME=CTMPLS, ALIAS=CTMpls, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='CTM Plan Sales', MEASURE_GROUP=MEASGRP_CTM,
PROPERTY=MEASURE, $
FIELDNAME=CTMCONF, ALIAS=CTMconf, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='CTM Confused Market Share', MEASURE_GROUP=MEASGRP_CTM,
PROPERTY=MEASURE, $
FIELDNAME=CTMCTM, ALIAS=CTMctm, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='CTM CTM Market Share', MEASURE_GROUP=MEASGRP_CTM,
PROPERTY=MEASURE, $
FIELDNAME=CTMGC, ALIAS=CTMgc, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='CTM Go Compare Market Share', MEASURE_GROUP=MEASGRP_CTM,
PROPERTY=MEASURE, $
FIELDNAME=CTMMSM, ALIAS=CTMmsm, USAGE=D20.2, ACTUAL=D8,
MISSING=ON,
TITLE='CTM MSM Market Share', MEASURE_GROUP=MEASGRP_CTM,
PROPERTY=MEASURE, $
DIMENSION=EXECMI, CAPTION='Calendar', DIM_TYPE=TIME, $
HIERARCHY=EXECMI, CAPTION='Report Calendar', HRY_DIMENSION=EXECMI, HRY_STRUCTURE=STANDARD, $
MEASUREGROUP=MEASGRP_FL, CAPTION='Frontline', $
MEASUREGROUP=MEASGRP_JN, CAPTION='Junction', $
MEASUREGROUP=MEASGRP_BN, CAPTION='Bennetts', $
MEASUREGROUP=MEASGRP_FU, CAPTION='Fusion', $
MEASUREGROUP=MEASGRP_ACM, CAPTION='ACM', $
MEASUREGROUP=MEASGRP_CTM, CAPTION='CTM', $
MEASUREGROUP=MEASGRP_IB, CAPTION='IB', $
COMPUTE FLLYNRR/D8.2%=(FLLYRA/FLLYRO)*100;,
TITLE='Frontline Last Year NRR', $
COMPUTE FLANRR/D8.2%=(FLARA/FLARO)*100;,
TITLE='Frontline Actual NRR', $
COMPUTE FLPLNRR/D8.2%=(FLPLRA/FLPLRO)*100;,
TITLE='Frontine Plan NRR', $
COMPUTE JNLYNRR/D8.2%=(JNLYRA/JNLYRO)*100;,
TITLE='Junction Last Year NRR', $
COMPUTE JNANRR/D8.2%=(JNARA/JNARO)*100;,
TITLE='Junction Actual NRR', $
COMPUTE JNPLNRR/D8.2%=(JNPLRA/JNPLRO)*100;,
TITLE='Junction Plan NRR', $
COMPUTE BTLYNRR/D8.2%=(BTLYRA/BTLYRO)*100;,
TITLE='Bennetts Last Year NRR', $
COMPUTE BTANRR/D8.2%=(BTARA/BTARO)*100;,
TITLE='Bennetts Actual NRR', $
COMPUTE BTPLNRR/D8.2%=(BTPLRA/BTPLRO)*100;,
TITLE='Bennetts Plan NRR', $

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

Hi Mike,

You have graphed values that are computed without a specification that they can contain missing data.

SUM COMPUTE JNLYNRR; AS 'Last Year'
COMPUTE JNPLNRR; AS 'Plan'
COMPUTE JNANRR; AS 'Actual'

Either lose the COMPUTE and semi colon or fully specify the compute such as -

SUM COMPUTE JNLYNRR/D12.2 MISSING ON = JNLYNRR; AS 'Last Year'
COMPUTE JNPLNRR/D12.2 MISSING ON = JNPLNRR; AS 'Plan'
COMPUTE JNANRR/D12.2 MISSING ON = JNANRR; AS 'Actual'

My best wishes for Christmas and the New Year to you and all the team in P'Boro!

T

To show you what I mean, using your graph style, consider the following code.

I extract the first value for MEDIUM without specifying MISSING ON but do so for NEW_MEDIUM.

DEFINE FILE GGSALES
  YEAR/YY         = DATE;
  YEARMNTH/MYY    = DATE;
  MNTH/M          = DATE;
  DATEYYMD/A8YYMD = EDIT(DATE);
  MONTH/A6        = GETTOK(CHGDAT('YYMD','MDYYT',DATEYYMD,'A17'), 6, 1, ' ', 6, 'A6');
END
TABLE FILE GGSALES
  SUM COMPUTE ACTUAL/D12.2 = IF MONTH NE 'MAY' THEN DOLLARS / 100000 ELSE 0;
      COMPUTE TARGET/D12.2 = IF MONTH NE 'MAY' THEN BUDDOLLARS / 100000 ELSE 0;
      COMPUTE MEDIUM/D12.2 = (ACTUAL + TARGET) / 2;
   BY YEAR
   BY MNTH
ON TABLE HOLD AS TEMPDATA FORMAT ALPHA
END
-RUN
DEFINE FILE TEMPDATA
  NEW_MEDIUM/D12.2 MISSING ON = IF MEDIUM EQ 0 THEN MISSING ELSE MEDIUM;
  MONTH/MT = MNTH;
END
GRAPH FILE TEMPDATA
  SUM MEDIUM
      NEW_MEDIUM
   BY YEAR
   BY MONTH
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 2
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBIRIACharcoal.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);
setMarkerShape(getAllSeries(),0);
setAutoSkip(getO1Label(),0);
setTextString(getO1Title(),"");
setMajorGridDrawEveryCount(getO1MajorGrid(),1);
setRiserBarGroupSpacing(1);
setTextRotation(getDataText(),0);
setLegendPosition(2);
setFillColor(getSeries(2),new Color(151,184,83));
setFillColor(getSeries(0),new Color(190,75,71));
setFillColor(getSeries(1),new Color(73,126,187));
setFillMissingData(0);
setTextFormatPattern(getY1Label(),"#.#");
setTextFormatPreset(getY1Label(),28);
setTextString(getTitle(),"Daily NRR%");
setDisplay(getTitle(),true);
ENDSTYLE
ON GRAPH SET STYLE *
TYPE=HEADING, LINE=1, ITEM=1, OBJECT=TEXT, SIZE=12, STYLE=NORMAL, $
ENDSTYLE
END

Good luck!

T

thanks for that! it worked!
I had to update my master to be as follows...

COMPUTE JNLYNRR/D8.2% MISSING ON=(JNLYRA/JNLYRO)*100;,
TITLE='Junction Last Year NRR', $
COMPUTE JNANRR/D8.2% MISSING ON=(JNARA/JNARO)*100;,
TITLE='Junction Actual NRR', $
COMPUTE JNPLNRR/D8.2% MISSING ON=(JNPLRA/JNPLRO)*100;,
TITLE='Junction Plan NRR', $

I didn't spot the missing was defaulted to OFF.

Have a greate xmas!