[SOLVED] SPC charts with automatic scale have not a good Y Scaling
Hello, All. This is my first post here !!!
I have made some charts to process control using one .fex for many charts. For some reason, some of them got correct scaled with setScaleMaxAuto(getY1Axis(),true) and setScaleMinAuto(getY1Axis(),true), as you see bellow: [IMG:left]http://s15.postimg.org/n612np94r/Good_Scaling.png [/IMG]
But, at the same time, some got wrong scale: [IMG:left]http://s27.postimg.org/hvqd67gdv/Bad_Scaling.png [/IMG] Why did this happens for automatic scale? I also tried to set automatic scales based on Upper (&USL) and Lower (&LSL) calculated Limits as bellow. But still not working. It seems parameters can not be used for setScaleMax or setScaleMin… Any help would be appreciated…
-* Begin MR Prefix *- -SET &SECTION='PREFIX'; -INCLUDE mrv/ppt.fex -* End MR Prefix *- DEFINE FILE VWPPT ADD -* DEFINE BEGIN DATETIME DATETIME/A16 = FPRINT(DATE_TIME,'HYYMDS','A16'); -* DEFINE END DATETIME LLSL/F20.2 = VWPPT.VWPPT.LSL; -SET &LSL = LLSL UUSL/F20.2 = VWPPT.VWPPT.USL ; -SET &USL = UUSL END GRAPH FILE VWPPT -* Begin MR Suffix *- -SET &SECTION='WHERE'; -INCLUDE mrv/ppt.fex -* End MR Suffix *- -* HTML Tool -* Created by Graph Assistant -* FF Line do not change this line! Field Name -* FF Line do not change this line! Alias -* FF Line do not change this line! Format -* FF Line do not change this line! Segment -* FF Line do not change this line! UseTitle -* FF Line do not change this line! displayTree=0 PRINT VWPPT.VWPPT.VALUE VWPPT.VWPPT.TARGET VWPPT.VWPPT.LSL VWPPT.VWPPT.USL BY VWPPT.VWPPT.NAME ACROSS DATETIME HEADING "<+0> () <&LSL> <&USL> <+0>" ON GRAPH SET LOOKGRAPH VLINE ON GRAPH SET 3D OFF ON GRAPH SET BARNUMB OFF ON GRAPH SET GRID ON ON GRAPH SET GRAPHEDIT SERVER ON GRAPH SET GRWIDTH 1 ON GRAPH SET VZERO OFF ON GRAPH SET VAXIS 300 ON GRAPH SET HAXIS 1500 ON GRAPH SET HTMLENCODE ON ON GRAPH SET GRAPHSTYLE *
setScaleMax(getY1Axis(),&USL); setScaleMin(getY1Axis(),&LSL);This message has been edited. Last edited by: <Kathryn Henning>,
WF 7703, Windows 2003 Server
December 22, 2014, 10:15 AM
Ram Prasad E
You have assigned SET variables within DEFINE and COMPUTE. This is not correct. You need to HOLD the max and min values, then READ from HOLD to assign values to SET variables. setScaleMax and setScaleMin will accept values from variables.
In below code, having a SET within DEFINE will assign a string ABCD and not its value.
DEFINE FILE CAR
ABCD/F20.2=SALES;
-SET &ABCD_1=ABCD;
END
-RUN
TABLE FILE CAR
PRINT
SALES
COUNTRY
ON TABLE HOLD
END
-RUN
-TYPE Value for ABCD_1: &ABCD_1
This message has been edited. Last edited by: Ram Prasad E,
If the -SET &ABCD=ABCD; on the example, assigned the string ABCD instead of its value, how to assign the ABCD value to &ABCD ??
According to your answer, I changed my code to bellow, but still not working... The limits of all graphics are locked on min: 0 max: 70 when should be from 1400 to 1500...
-* Begin MR Prefix *-
-SET &SECTION='PREFIX';
-INCLUDE mrv/ppt.fex
-* End MR Prefix *-
DEFINE FILE VWPPT ADD
-* DEFINE BEGIN DATETIME
DATETIME/A16 = FPRINT(DATE_TIME,'HYYMDS','A16');
-* DEFINE END DATETIME
END
TABLE FILE VWPPT
-* Begin MR Suffix *-
-SET &SECTION='WHERE';
-INCLUDE mrv/ppt.fex
-* End MR Suffix *-
-* HTML Tool
-* Created by Graph Assistant
-* FF Line do not change this line! Field Name
-* FF Line do not change this line! Alias
-* FF Line do not change this line! Format
-* FF Line do not change this line! Segment
-* FF Line do not change this line! UseTitle
-* FF Line do not change this line! displayTree=0
PRINT VWPPT.VWPPT.VALUE
COMPUTE USLVALUE/I5 = USL ;
COMPUTE LSLVALUE/I5 = LSL ;
VWPPT.VWPPT.TARGET
VWPPT.VWPPT.AREA
VWPPT.VWPPT.NAME
VWPPT.VWPPT.MEASUREMENTUNIT
VWPPT.VWPPT.DATETIME
BY VWPPT.VWPPT.NAME
WHERE VWPPT.VWPPT.AREA ='Forno'
ON GRAPH HOLD AS WTC
END
GRAPH FILE WTC
PRINT VALUE TARGET USLVALUE LSLVALUE
ACROSS DATETIME
BY NAME
HEADING
" <AREA> <NAME> (<MEASUREMENTUNIT>) "
WHERE AREA = 'Forno';
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 300
ON GRAPH SET HAXIS 1500
ON GRAPH SET GRWIDTH 1
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
-SET &U = USLVALUE;
-SET &L = LSLVALUE;
setScaleMaxAuto(getY1Axis(),false);
setScaleMinAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),&U);
setScaleMin(getY1Axis(),&L);
setSeriesType($0,2);
setSeriesType($1,2);
setSeriesType($2,2);
setSeriesType($3,2);
This message has been edited. Last edited by: Rogério,
WF 7703, Windows 2003 Server
February 03, 2015, 01:47 PM
MartinY
Hi Rogerio,
First as mentioned already don't put -SET command between DEFINE ... END or TABLE FILE ... END as you did.
Second to assign a value : -SET &UL = &USL.EVAL;
Third always end you -SET command with a semi-column « ; »
Fourth doing :
-SET &SECTION='WHERE';
...
-SET &U = USLVALUE;
are invalid because you put -SET command between TABLE ... END and you cannot assign to a variable (&U) the content of a field (USLVALUE) that way.
You will first need to extract USL and LSL value from something like that
TABLE FILE ...
PRINT USL
LSL
WHERE...
ON TABLE HOLD AS VAL FORMAT ALPHA
END
-RUN
-READ VAL &USL.I5. &LSL.I5.
-RUN
and insure that you'll only have one record to read. Then you'll be able to use
setScaleMax(getY1Axis(),&USL.EVAL);
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
February 04, 2015, 05:33 AM
Rogério
I need to read a pair of values for each chart scale. How to set the -READ to acomplish that?
WF 7703, Windows 2003 Server
February 04, 2015, 08:24 AM
MartinY
I don't understand why you would like to set different Min / Max per graph when WF does it for you. See sample:
-*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+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJNYXN0ZXJfRmlsZXMiIHR5cGU9IlNldCIgPgogICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPkZJTkFOQ0U8L0VudHJ5PgogICAgICA8L1Byb3BlcnR5PgogICA8L09iamVjdD4KPC9Sb290Pg==
-*Do not delete or modify the comments above
GRAPH FILE FINANCE
-* Created by Advanced Graph Assistant
SUM AMOUNT
BY ACCOUNT
ACROSS YEAR
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 250
ON GRAPH SET VAXIS 300
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 1
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setTransparentBorderColor(getChartBackground(),true);
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);
setPlace(true);
ENDSTYLE
END
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
February 04, 2015, 08:59 AM
Rogério
Thanks for the sample... Your charts are pretty well scaled...
I dont know why, mine look like these (only the last 2 graphs are good):
Any reason for that? My current fex:
-* Begin MR Prefix *-
-SET &SECTION='PREFIX';
-INCLUDE mrv/ppt.fex
-* End MR Prefix *-
DEFINE FILE VWPPT ADD
-* DEFINE BEGIN DATETIME
DATETIME/A16 = FPRINT(DATE_TIME,'HYYMDS','A16');
-* DEFINE END DATETIME
END
TABLE FILE VWPPT
-* Begin MR Suffix *-
-SET &SECTION='WHERE';
-INCLUDE mrv/ppt.fex
-* End MR Suffix
-* HTML Tool
-* Created by Graph Assistant
-* FF Line do not change this line! Field Name
-* FF Line do not change this line! Alias
-* FF Line do not change this line! Format
-* FF Line do not change this line! Segment
-* FF Line do not change this line! UseTitle
-* FF Line do not change this line! displayTree=0
PRINT VALUE
COMPUTE USLVALUE/D12.2 = USL ;
COMPUTE LSLVALUE/D12.2 = LSL ;
TARGET
AREA
NAME
MEASUREMENTUNIT
DATETIME
BY NAME
WHERE AREA ='Forno'
ON TABLE HOLD AS WTC
END
GRAPH FILE WTC
PRINT VALUE TARGET USLVALUE LSLVALUE
ACROSS DATETIME
BY NAME
HEADING
" <AREA> <NAME> (<MEASUREMENTUNIT>) "
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 300
ON GRAPH SET HAXIS 1500
ON GRAPH SET GRWIDTH 1
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setSeriesType($0,2);
setSeriesType($1,2);
setSeriesType($2,2);
setSeriesType($3,2);
setLegendDisplay(false);
setMarkerDisplay(true);
setUseSeriesShapes(true);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MustIncludeZero(false);
setTextFormatPreset(getY1Label(),1);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setFillMissingData(2);
setFontName(getO1Label(),"Arial Unicode MS");
setFontSize(getO1Label(),8);
setFontSizeAbsolute(getO1Label(),true);
setPlaceResize(getO1Label(),0);
setTextRotation(getO1Label(),3);
setPlaceRotate(getO1Label(),0);
setTextJustHoriz(getO1Label(),2);
setPlaceAlign(getO1Label(),0);
setTextWrap(getO1Label(),false);
setPlaceWordWrap(getO1Label(),0);
setFillColor(getO1Title(),new Color(255,255,255));
setFontSize(getO1Title(),8);
setFontSizeAbsolute(getO1Title(),true);
setPlaceResize(getO1Title(),0);
setFontStyle(getO1Title(),0);
setTextRotation(getO1Title(),0);
setPlaceRotate(getO1Title(),0);
setTextJustHoriz(getO1Title(),1);
setPlaceAlign(getO1Title(),0);
setTextWrap(getO1Title(),false);
setPlaceWordWrap(getO1Title(),0);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
TYPE=DATA, ACROSSCOLUMN=VWPPT.VWPPT.VALUE , COLOR=rgb(0 0 255), $
TYPE=DATA, ACROSSCOLUMN=VWPPT.VWPPT.TARGET , COLOR=rgb(0 255 0), $
TYPE=DATA, ACROSSCOLUMN=VWPPT.VWPPT.LSL , COLOR=rgb(255 255 0), $
TYPE=DATA, ACROSSCOLUMN=VWPPT.VWPPT.USL , COLOR=rgb(255 255 0), $
TYPE= HEADING,$
ENDSTYLE
ON GRAPH PCHOLD AS HOLD FORMAT PNG
END
-* End Graph Assistant
-SET &SECTION='SUFFIX';
-INCLUDE mrv/ppt.fex
WF 7703, Windows 2003 Server
February 04, 2015, 11:08 AM
MartinY
I can't see your image because you must first add it per example to tinypic.com and then add the link to it.
But even without that, it doesn't seems that it's related to the styling of your graph because if you put your styling in my graph, it scale the Min/Max perfectly per graph.
Just the second line
ON GRAPH PCHOLD AS HOLD FORMAT PNG
at the end may be removed because don't need to exist twice and
So what I suggest it's to use "my styling" in your report and see if it does scale properly. If not, look at your data.
Also, put back
-* HTML Tool
-* Created by Graph Assistant
-* FF Line do not change this line! Field Name
-* FF Line do not change this line! Alias
-* FF Line do not change this line! Format
-* FF Line do not change this line! Segment
-* FF Line do not change this line! UseTitle
-* FF Line do not change this line! displayTree=0
where it should be : at the definition of the graph, not at the TABLE FILE VWPPT.
Another suggestion : start over your graph with graph assistant and look at the differences with actual code.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
February 04, 2015, 12:53 PM
Rogério
I tried to start from scratch using the graph assistant, but the result is aways the same. My pictures URLs:
Bellow is one sample of my data. Im trying to plot a line absolute graph, but WF sets my YScale to min 0 max 1400 when something from 1200 to 1215 would be reasonable...
According to your sample, it seems that it's not all the same Y scaling value: Celcius and mm.
A suggestion will be to create each graph independently to finally merge them.
First extract the minimum and maximum value for the scale. Par example if the min is 1208.0059 then keep the whole part of the number (1208). Hold as ALPHA, -READ the value as mentioned earlier.
DEFINE FILE x
MIN /D6 = USL;
MAX /D6 = LSL;
END
Second increase and decrease it from a certain value. Subtract let say 100 and use it as your min. Do the same for the max and add 100. Now you have:
-SET &MIN = &MIN - 100;
-SET &MAX = &MAX + 100;
Third create your GRAPH and assign &MIN and &MAX to the min/max of the graph.
Fifth, create compound report with Composer having all the graphs.
It's only the concept, may possibly need more code
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
February 27, 2015, 06:12 AM
Rogério
Hello, My final solution was to create separate graphs as the 2 bellow .Each of it with its own set of limits manually configured. It is not the best solution, but it works as far as the limits do not vary.
DEFINE FILE VWPPT ADD
DATETIME/A16 = FPRINT(DATE_TIME,'HYYMDS','A16');
END
-*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+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJNYXN0ZXJfRmlsZXMiIHR5cGU9IlNldCIgPgogICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPlZXUFBUPC9FbnRyeT4KICAgICAgPC9Qcm9wZXJ0eT4KICAgPC9PYmplY3Q+CjwvUm9vdD4=
-*Do not delete or modify the comments above
GRAPH FILE VWPPT
-* Created by Advanced Graph Assistant
SUM VWPPT.VWPPT.VALUE
VWPPT.VWPPT.USL
VWPPT.VWPPT.LSL
VWPPT.VWPPT.TARGET
ACROSS DATETIME
WHERE VWPPT.VWPPT.NAME EQ 'Afino # 1';
HEADING
" <AREA> <NAME> (<MEASUREMENTUNIT>) "
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 1300
ON GRAPH SET VAXIS 300
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/IBISouthWestern.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);
setY1OffScaleDisplay(false);
setScaleFromZero(false);
setNonZeroBaselineValue(getY1Axis(),1.234567E301);
setDisplay(getY1AltFmtFrame(),false);
setGridStepAuto(getY1MajorGrid(),true);
setScaleMustIncludeZero(getY1Axis(),false);
setLogScaleBase(getY1Axis(),1.0);
setLogScale(getY1Axis(),false);
setLineBasicStrokeType(getO1MajorGrid(),11);
setLineWidth(getO1MajorGrid(),1);
setLineWidth(getY1MajorGrid(),1);
setDisplay(getY1MajorGrid(),true);
setLineBasicStrokeType(getY1MajorGrid(),11);
setFillColor(getChartBackground(),new Color(255,255,255));
setFillColor(getO1MajorGrid(),new Color(0,0,0));
setGridStyle(getO1MajorGrid(),0);
setGridStyle(getY1MajorGrid(),0);
setScaleMaxAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),1450.0);
setScaleMinAuto(getY1Axis(),false);
setScaleMin(getY1Axis(),1430.0);
setTextRotation(getO1Label(),3);
ENDSTYLE
ON GRAPH SET STYLE *
TYPE=HEADING, LINE=1, ITEM=1, OBJECT=TEXT, SIZE=12, STYLE=NORMAL, $
ENDSTYLE
END
-*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+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJNYXN0ZXJfRmlsZXMiIHR5cGU9IlNldCIgPgogICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPlZXUFBUPC9FbnRyeT4KICAgICAgPC9Qcm9wZXJ0eT4KICAgPC9PYmplY3Q+CjwvUm9vdD4=
-*Do not delete or modify the comments above
GRAPH FILE VWPPT
-* Created by Advanced Graph Assistant
SUM VWPPT.VWPPT.VALUE
VWPPT.VWPPT.USL
VWPPT.VWPPT.LSL
VWPPT.VWPPT.TARGET
ACROSS DATETIME
WHERE VWPPT.VWPPT.AREA EQ 'Forno' AND VWPPT.VWPPT.NAME EQ 'MB # 1 (Forno)';
HEADING
" <AREA> <NAME> (<MEASUREMENTUNIT>) "
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 1300
ON GRAPH SET VAXIS 300
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/IBISouthWestern.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);
setY1OffScaleDisplay(false);
setScaleFromZero(false);
setNonZeroBaselineValue(getY1Axis(),1.234567E301);
setDisplay(getY1AltFmtFrame(),false);
setGridStepAuto(getY1MajorGrid(),true);
setScaleMustIncludeZero(getY1Axis(),false);
setLogScaleBase(getY1Axis(),1.0);
setLogScale(getY1Axis(),false);
setLineBasicStrokeType(getO1MajorGrid(),11);
setLineWidth(getO1MajorGrid(),1);
setLineWidth(getY1MajorGrid(),1);
setDisplay(getY1MajorGrid(),true);
setLineBasicStrokeType(getY1MajorGrid(),11);
setFillColor(getChartBackground(),new Color(255,255,255));
setFillColor(getO1MajorGrid(),new Color(0,0,0));
setGridStyle(getO1MajorGrid(),0);
setGridStyle(getY1MajorGrid(),0);
setScaleMaxAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),1250.0);
setScaleMinAuto(getY1Axis(),false);
setScaleMin(getY1Axis(),1200.0);
setTextRotation(getO1Label(),3);
ENDSTYLE
ON GRAPH SET STYLE *
TYPE=HEADING, LINE=1, ITEM=1, OBJECT=TEXT, SIZE=12, STYLE=NORMAL, $
ENDSTYLE
END