GRAPH FILE SAMPLE_MFD -* CREATED BY INFO ASSIST FOR GRAPH SUM COMPUTE WORKLOAD/D12.2=SAMPLE_MFD.DATA_1/SAMPLE_MFD.DATA_2 ; AS 'CHART_DATA' BY SAMPLE_MFD.AGENCY ACROSS SAMPLE_MFD.CUSTOM_MONTH_YEAR WHERE SAMPLE_MFD.CUSTOM_YEAR_MONTH_INT GT USER_INPUT_YEAR_MONTH_START AND SAMPLE_MFD.CUSTOM_YEAR_MONTH_INT LE USER_INPUT_YEAR_MONTH_END; HEADING 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 HAXIS 770.0 ON GRAPH SET VAXIS 405.0 ON GRAPH SET GRMERGE ADVANCED ON GRAPH SET GRMULTIGRAPH 0 ON GRAPH SET GRLEGEND 1 ON GRAPH SET GRXAXIS 1 ON GRAPH SET LOOKGRAPH VLINE ON GRAPH SET STYLE *This message has been edited. Last edited by: FP Mod Chuck,
quote:Originally posted by BabakNYC:
What is the format of your MONTH_YEAR column? I think if you use standard date formats you can translate a month number to the month name and it'll sort properly.
quote:Originally posted by Tom Flynn:
Sandeep,
Try using your numeric month, ACROSS CUSTOM_YEAR_MONTH_INT NOPRINT and change GRXAXIS from 1 to 2...
Probably won't work changing the GRXAXIS; should be able to use CUSTOM_YEAR_MONTH_INT NOPRINT as the 1st ACROSS statement, done this many times...
GRAPH FILE SAMPLE_MFD -* CREATED BY INFO ASSIST FOR GRAPH SUM COMPUTE WORKLOAD/D12.2=SAMPLE_MFD.DATA_1/SAMPLE_MFD.DATA_2 ; AS 'CHART_DATA' BY SAMPLE_MFD.AGENCY ACROSS SAMPLE_MFD.CUSTOM_MONTH_YEAR_INT NOPRINT ACROSS SAMPLE_MFD.CUSTOM_MONTH_YEAR WHERE SAMPLE_MFD.CUSTOM_MONTH_YEAR_INT GT USER_INPUT_YEAR_MONTH_START AND SAMPLE_MFD.CUSTOM_MONTH_YEAR_INT LE USER_INPUT_YEAR_MONTH_END; HEADING 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 HAXIS 770.0 ON GRAPH SET VAXIS 405.0 ON GRAPH SET GRMERGE ADVANCED ON GRAPH SET GRMULTIGRAPH 0 ON GRAPH SET GRLEGEND 1 ON GRAPH SET GRXAXIS 2 ON GRAPH SET LOOKGRAPH VLINE ON GRAPH SET STYLE *
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206 |
quote:I'm sure someone, maybe me, will jump in if you can duplicate this using one of the ibisamp files, GGSALES?.
-SET &USER_INPUT_YEAR_MONTH_START = 199601; -SET &USER_INPUT_YEAR_MONTH_END = 199612; DEFINE FILE GGSALES CUSTOM_MONTH_YEAR_INT/I8 = EDIT(EDIT(DATE,'999999')); CUSTOM_MONTH_YEAR/A20 = EDIT(DATE,'9999') || '-' || EDIT(DATE,'$$$$99'); END TABLE FILE GGSALES SUM COMPUTE DATA_1/I08 = DOLLARS; COMPUTE DATA_2/I08 = UNITS; COMPUTE AGENCY/A20 = REGION; CUSTOM_MONTH_YEAR BY CUSTOM_MONTH_YEAR_INT ON TABLE HOLD AS HOLDSAMP END -RUN GRAPH FILE HOLDSAMP -* CREATED BY INFO ASSIST FOR GRAPH SUM COMPUTE WORKLOAD/D12.2=DATA_1/DATA_2 ; AS 'CHART_DATA' BY AGENCY ACROSS CUSTOM_MONTH_YEAR_INT NOPRINT ACROSS CUSTOM_MONTH_YEAR WHERE CUSTOM_MONTH_YEAR_INT GT &USER_INPUT_YEAR_MONTH_START AND CUSTOM_MONTH_YEAR_INT LE &USER_INPUT_YEAR_MONTH_END; HEADING 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 HAXIS 770.0 ON GRAPH SET VAXIS 405.0 ON GRAPH SET GRMERGE ADVANCED ON GRAPH SET GRMULTIGRAPH 0 ON GRAPH SET GRLEGEND 1 ON GRAPH SET GRXAXIS 2 ON GRAPH SET LOOKGRAPH VLINE ON GRAPH SET STYLE * END
SET ASNAMES = ON DEFINE FILE GGSALES CUSTOM_MONTH_YEAR_INT/I8 = EDIT(EDIT(DATE,'999999')); CUSTOM_MONTH_YEAR/A20 = EDIT(DATE,'9999') || '-' || EDIT(DATE,'$$$$99'); X_MONTH/A2 = EDIT(DATE,'$$$$99'); Y_MONTH/A4 = DECODE X_MONTH( '01' 'Jan-' '02' 'Feb-' '03' 'Mar-' '04' 'Apr-' '05' 'May-' '06' 'Jun-' '07' 'Jul-' '08' 'Aug-' '09' 'Sep-' '10' 'Oct-' '11' 'Nov-' '12' 'Dec-' ELSE 'UNK-'); Z_MONTH_YR/A8 = Y_MONTH || EDIT(DATE,'9999'); END TABLE FILE GGSALES SUM COMPUTE DATA_1/I08 = DOLLARS; COMPUTE DATA_2/I08 = UNITS; CUSTOM_MONTH_YEAR Z_MONTH_YR BY PRODUCT AS 'AGENCY' BY CUSTOM_MONTH_YEAR_INT ON TABLE HOLD AS HOLDSAMP END -RUN GRAPH FILE HOLDSAMP -* CREATED BY INFO ASSIST FOR GRAPH SUM COMPUTE WORKLOAD/D12.2=DATA_1/DATA_2 ; AS 'CHART_DATA' BY AGENCY BY CUSTOM_MONTH_YEAR_INT NOPRINT BY Z_MONTH_YR AS 'Month/YR' WHERE CUSTOM_MONTH_YEAR_INT GT &USER_INPUT_YEAR_MONTH_START AND CUSTOM_MONTH_YEAR_INT LE &USER_INPUT_YEAR_MONTH_END; 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 HAXIS 770.0 ON GRAPH SET VAXIS 405.0 ON GRAPH SET GRMERGE ADVANCED ON GRAPH SET GRMULTIGRAPH 0 ON GRAPH SET GRLEGEND 1 ON GRAPH SET GRXAXIS 2 ON GRAPH SET LOOKGRAPH VLINE ON GRAPH SET STYLE * END -EXIT
SET ASNAMES = ON
DEFINE FILE GGSALES
CUSTOM_MONTH_YEAR_INT/I8 = EDIT(EDIT(DATE,'999999'));
CUSTOM_MONTH_YEAR/A20 = EDIT(DATE,'9999') || '-' || EDIT(DATE,'$$$$99');
X_MONTH/A2 = EDIT(DATE,'$$$$99');
Y_MONTH/A4 = DECODE X_MONTH(
'01' 'Jan-'
'02' 'Feb-'
'03' 'Mar-'
'04' 'Apr-'
'05' 'May-'
'06' 'Jun-'
'07' 'Jul-'
'08' 'Aug-'
'09' 'Sep-'
'10' 'Oct-'
'11' 'Nov-'
'12' 'Dec-'
ELSE 'UNK-');
Z_MONTH_YR/A8 = Y_MONTH || EDIT(DATE,'9999');
END
TABLE FILE GGSALES
SUM
COMPUTE DATA_1/I08 = DOLLARS;
COMPUTE DATA_2/I08 = UNITS;
CUSTOM_MONTH_YEAR
Z_MONTH_YR
BY PRODUCT AS 'AGENCY'
BY CUSTOM_MONTH_YEAR_INT
WHERE CUSTOM_MONTH_YEAR_INT GT &USER_INPUT_YEAR_MONTH_START AND CUSTOM_MONTH_YEAR_INT LE &USER_INPUT_YEAR_MONTH_END;
ON TABLE HOLD AS HOLDSAMP
-*ON TABLE PCHOLD FORMAT HTML
END
-RUN
-*IA_GRAPH_BEGIN
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT CREATED BY INFO ASSIST FOR GRAPH
-*Do not delete or modify the comments above
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT CREATED BY INFO ASSIST FOR GRAPH
-*Do not delete or modify the comments above
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9Im5vIj8+DQo8IS0tMS4wLS0+PFJvb3QgdmVyc2lvbj0iMS4xIj4NCiAgICA8T2JqZWN0IG9iamVjdElkPSJDaGFydF8xIj4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9IkxpbmtlZFNvcnRzIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIi8+DQogICAgPC9PYmplY3Q+DQogICAgPE9iamVjdCBvYmplY3RJZD0iR0xPQkFMIj4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9IlNhbXBsZURhdGEiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIj5mYWxzZTwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJHbG9iYWxSZWNvcmRMaW1pdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+NTAwPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbFJ1blJlY29yZExpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj4wPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbE9wdGltaXphdGlvbiIgdHlwZT0iamF2YS5sYW5nLkJvb2xlYW4iPnRydWU8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iZmllbGREaXNwbGF5TW9kZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+bGFiZWw8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0icHJlZml4RGlzcGxheU1vZGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciLz4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9IkFjdGl2ZV9TdHlsZV9Vc2VyX3R5cGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnBvd2VyPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbFZhbHVlc1BhZ2luZyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+NDwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJGb2NleGVjUHJlZmVyZW5jZXMiIHR5cGU9Ik1hcCI+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkVkaXRJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlTZXJpZXNUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImF1dG9EcmlsbFNjcmlwdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIvPg0KICAgICAgICAgICAgPEVudHJ5IGtleT0icnVuT25TdGFydHVwRGVmZXJyZWRJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlFZGl0TW9kZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUhvbWVUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9Im1ldGFkYXRhX3ZpZXdzIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5NZXRhRGF0YVRyZWUuVklFV19ESU1TPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlEYXRhVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJpbmZvQXNzaXN0TW9kZUFsbG93ZWRJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfcHJldmlld19wYWdlbGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPjU8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUluc2VydFRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0icnVuT25TdGFydHVwSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj50cnVlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlMYXlvdXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlJbnRlcmFjdGl2ZU1vZGVJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnRydWU8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF9wcmV2aWV3X3BhZ2VsaW1pdF9sYXlvdXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPjE8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVF1aWNrQWNjZXNzVG9vbGJhclNhdmVJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnRydWU8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNsaWNlcnNUYWJJbnRlcmFjdGl2ZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+dHJ1ZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X2NvbXBvc2VfZm9ybWF0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5QREY8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVJlc291cmNlc0ZpZWxkVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5Rm9ybWF0VGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj50cnVlPC9FbnRyeT4NCiAgICAgICAgPC9Qcm9wZXJ0eT4NCiAgICAg
*-INTERNAL_COMMENT LINE#1$ICAgPFByb3BlcnR5IG5hbWU9ImNhc2NhZGVOYW1lcyIgdHlwZT0iTWFwIi8+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJNYXN0ZXJfRmlsZXMiIHR5cGU9IlNldCI+DQogICAgICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+SE9MRFNBTVA8L0VudHJ5Pg0KICAgICAgICA8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0ibWV0YWRhdGFWaWV3QXMiIHR5cGU9Ik1hcCI+DQogICAgICAgICAgICA8RW50cnkga2V5PSJIT0xEU0FNUCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+TWV0YURhdGFUcmVlLlZJRVdfRElNUzwvRW50cnk+DQogICAgICAgIDwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJlbmFibGVQcmV2aWV3IiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiI+dHJ1ZTwvUHJvcGVydHk+DQogICAgPC9PYmplY3Q+DQo8L1Jvb3Q+DQo=
-*Do not delete or modify the comments above
ENGINE INT CACHE SET ON
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE HOLDSAMP
-* Created by Info Assist for Graph
SUM COMPUTE WORKLOAD/D12.2=DATA_1/DATA_2 ; AS 'CHART_DATA'
BY HOLDSAMP.HOLDSAMP.Z_MONTH_YR
ACROSS HOLDSAMP.HOLDSAMP.AGENCY
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
setUseSeriesShapes(true);
setMarkerSizeDefault(50);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setConnectLineMarkers(true);
setCurveFitType(0,0);
setCurveFitType(1,0);
setCurveFitType(2,0);
setCurveFitType(3,0);
setCurveFitType(4,0);
setCurveFitType(5,0);
setCurveFitType(6,0);
setCurveFitType(7,0);
setCurveFitType(8,0);
setCurveFitType(9,0);
setSeriesType(0,2);
setSeriesType(1,2);
setSeriesType(2,2);
*END
ENDSTYLE
END
-RUN
-*IA_GRAPH_FINISH