Optimization Graphing Favorite - SQL details

You can use the OPT Graphing page to build and save a graph favorite, or you can manually manipulate the string that adds all the datapoints for the graph.

Here is an example:

26-DailyDev,1,line,0,0;

OPTid	Type Of Data to Plot	Axis	Plot Type	Show Zeros	Connect Gaps in Data

OPTid	Type Of Data to Plot	Axis	Plot Type	Show Zeros	Connect Gaps in Data
26	DailyDev	1	Line	0 for FALSE	0 for FALSE
	DailyAvg	11	smoothedLine	1 for TRUE	1 for TRUE
		2
		21

You can see this raw data in its SQL table by running this query SELECT FavoriteID,FavoriteName,OPTGraphShowARYOPTids FROM tblOPT_GraphFavorite

From this page Maintenance Selector: ~/reports/maintenanceselector.aspx

All datapoints need to be separated by a ;

If you want us to update the OPT Graph for you, send us what the FavoriteID is and the string with the site name.

Plant Focus Knowledge Base

Optimization Graphing Favorite - SQL details

Analytics