Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
825
|
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 3D Linear Regression Chart
--
-- Notes: The query below will work on the following database servers:
-- MS SQL Server, Sybase ASE, Sybase IQ, Sybase Anywhere, MySQL, PostreSQL
--
-- ORACLE: To make the query below work in Oracle, add " FROM DUAL" at the end of each SELECT
-- DB2: To make the query below work in DB2, add " FROM SYSIBM.SYSDUMMY1" at the end of each SELECT
-------------------------------------------------------------------------------------------------------------------------------------------------------------
select 1 as category, 25 as s1
union
select 2 as category, 18 as s1
union
select 3 as category, 20 as s1
union
select 4 as category, 40 as s1
union
select 5 as category, 50 as s1
union
select 6 as category, 40 as s1
union
select 7 as category, 60 as s1
union
select 8 as category, 52 as s1
union
select 9 as category, 55 as s1
union
select 10 as category, 73 as s1
GO
.setResultSettings 'Index=1,
CategoryFields="[category]",
SeriesFields="[s1]",
ShowChart=true,
ShowToolbar=true,
Paging=true,
Split=0,
Chart="{scatter,line}",
RotX=315,
RotY=0,
RotZ=0,
ZoomScalar=1.7588234,
ShowLegend=true,
ShowLegendBorder=true,
ShowGrid=true,
FillGrid=true,
GridLineWidth=1.0,
Title="3D Linear Regression",
TitlePosition="Bottom Center",
TitleCategory="",
TitleValue="",
PieExplode=0.0,
GroupSmallValues=true,
SmallValuesThreshold=3.0,
PieLabelDistance=3.0,
PieShowLines=false,
LineWidth=1.0,
ShowMarkers=true,
MapShowBackground=false,
MapShowDetails=false,
MapRange="",
MapRangeColors="",
Width=16.0,
Height=10.0,
Depth=4.0,
SeriesSpacing=0.5,
CategorySpacing=0.5,
Font=Arial-PLAIN-6,
LegendFontSize=1.0,
SeriesFontSize=1.0,
CategoryFontSize=1.0,
ValueFontSize=1.0,
TitleFontSize=1.75,
AxisTitleFontSize=1.25,
DataLabelFontSize=1.0,
TopColor=#d7dcf5,
BottomColor=#ebf0f5,
PanX=-9.499998,
PanY=-3.6,
Lighting=Default,
Opacity=1.0,
View2D=false,
FitChartToImage=false,
StackedPercent=false,
ShowValueAxis=true,
ShowValueAxisTicks=true,
ShowValueAxisLines=true,
ReverseValueAxis=false,
ShowCategoryAxis=true,
ShowCategoryAxisTicks=true,
ShowCategoryAxisLines=true,
ShowSeriesAxis=false,
ShowDataLabels=false,
ValueAxisNumberFormat="###0",
CategoryAxisNumberFormat="#,##0",
CategoryAxisDateFormat="",
CategoryAxisDateTimeFormat="",
CategoryAxisTimeFormat="",
SeriesAxisNumberFormat="",
SeriesAxisDateFormat="",
SeriesAxisDateTimeFormat="",
SeriesAxisTimeFormat="",
NumericCategoryAxis=false,
MergeAxis=true,
SeriesAlias="default,default",
SeriesFunction="Linear Regression ( 0 ) ",
SeriesSubType=",",
SeriesColumnType="Cube,Cube",
SeriesMin="default,default",
SeriesMax="default,default",
SeriesColor="#40699d,#9f413e",
SeriesFunctionMetaData="true,false",
ShowSeriesDataLabels="false,false",
LegendPosition=Top Right,
LegendWidthType=Fit,
LegendWidth=100,
LegendHeightType=Fit,
LegendHeight=160,
ShowFixedCategoryCount=false,
FixedCategoryCount=0'
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017