Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] SPC charts with automatic scale have not a good Y Scaling

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] SPC charts with automatic scale have not a good Y Scaling
 Login/Join
 
Member
posted
Hello, All. This is my first post here Big Grin !!!

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 *

setY1MustIncludeZero(false);
setScaleMaxAuto(getY1Axis(),false);
setScaleMinAuto(getY1Axis(),false);

setScaleMax(getY1Axis(),&USL);
setScaleMin(getY1Axis(),&LSL);

This message has been edited. Last edited by: <Kathryn Henning>,


WF 7703, Windows 2003 Server
 
Posts: 8 | Registered: December 19, 2014Report This Post
Master
posted Hide Post
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,
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Member
posted Hide Post
Hello, Ram Prasad.
Thanks for the answer !

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
 
Posts: 8 | Registered: December 19, 2014Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Member
posted Hide Post
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
 
Posts: 8 | Registered: December 19, 2014Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Member
posted Hide Post
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
 
Posts: 8 | Registered: December 19, 2014Report This Post
Virtuoso
posted Hide Post
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
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

have no effect with my sample.

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
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Member
posted Hide Post
I tried to start from scratch using the graph assistant, but the result is aways the same.
My pictures URLs:

http://postimg.org/image/ygpcv60fh/
http://postimg.org/image/3ns1quwml/

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...

1212.8757
1213.5385
1214.1273
1213.9801
1213.8329
1213.6058
1208.0059
1211.979
1211.8196
1211.0472
1211.5277
1209.4635
1208.9473
1213.4292
1213.7554
1212.3496
1212.1394
1211.8962
1212.2382
1211.1818
1211.2552
1211.7712
1211.5499
1212.2026
1212.4137
1210.8131
1210.7393
1211.4056
1210.9028
1211.845
1210.6674
1210.4446
1210.5696
1210.7273
1210.0488
1210.4446
1210.002
1211.1594
1211.4399
1210.7391
1211.6169
1211.0175
1212.0435
1212.7252
1211.9653
1211.2338
1211.2728
1210.9381
1211.675


WF 7703, Windows 2003 Server
 
Posts: 8 | Registered: December 19, 2014Report This Post
Virtuoso
posted Hide Post
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.
setScaleMin(getY1Axis(),&MIN.EVAL);
setScaleMax(getY1Axis(),&MAX.EVAL);


Fourth, repeat for all graph.

Fifth, create compound report with Composer having all the graphs.

It's only the concept, may possibly need more code Wink


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
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
Member
posted Hide Post
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



WF 7703, Windows 2003 Server
 
Posts: 8 | Registered: December 19, 2014Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] SPC charts with automatic scale have not a good Y Scaling

Copyright © 1996-2020 Information Builders