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
|
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 2D Zero Crossing 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 'A' as category, 25 as s1, 24 as s2, 23 as s3, 22 as s4, 21 as s5
union
select 'B' as category, -15 as s1, -13 as s2, 0 as s3, 3 as s4, 5 as s5
union
select 'C' as category, 35 as s1, 2 as s2, 0 as s3, 5 as s4, -5 as s5
union
select 'D' as category, -7 as s1, -6 as s2, 0 as s3, 3 as s4, -3 as s5
union
select 'E' as category, 25 as s1, 24 as s2, 0 as s3, 5 as s4, -2 as s5
union
select 'F' as category, 0 as s1, 1 as s2, 3 as s3, 5 as s4, -3 as s5
union
select 'G' as category, 1 as s1, 0 as s2, 4 as s3, 6 as s4, -6 as s5
union
select 'H' as category, 9 as s1, 4 as s2, 2 as s3, 0 as s4, -3 as s5
union
select 'I' as category, -2 as s1, 0 as s2, 3 as s3, 5 as s4, 7 as s5
union
select 'K' as category, -1 as s1, -3 as s2, 0 as s3, 4 as s4, 6 as s5
union
select 'M' as category, 0 as s1, 1 as s2, 4 as s3, 6 as s4, 8 as s5
union
select 'O' as category, -5 as s1, -3 as s2, 4 as s3, 2 as s4, 0 as s5
union
select 'P' as category, 3 as s1, 0 as s2, 1 as s3, -4 as s4, -6 as s5
union
select 'T' as category, 1 as s1, 3 as s2, 0 as s3, -4 as s4, 8 as s5
union
select 'W' as category, -4 as s1, 0 as s2, -1 as s3, 5 as s4, 7 as s5
union
select 'Z' as category, 0 as s1, 3 as s2, 5 as s3, -2 as s4, -4 as s5
GO
.setResultSettings 'Index=1,
CategoryFields="[category]",
SeriesFields="[s1],[s2],[s3],[s4],[s5]",
ShowChart=true,
ShowToolbar=true,
Paging=true,
Split=0,
Chart="{scatter,scatter,scatter,scatter,scatter}",
RotX=324,
RotY=0,
RotZ=0,
ZoomScalar=1.1625924,
ShowLegend=true,
ShowLegendBorder=true,
ShowGrid=true,
FillGrid=true,
GridLineWidth=1.0,
Title="2D Zero Crossing Chart",
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=8.0,
SeriesSpacing=0.25,
CategorySpacing=0.25,
Font=Arial-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=-280.3,
PanY=-147.9,
Lighting=Default,
Opacity=1.0,
View2D=true,
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,default,default,default",
SeriesSubType=",,,,",
SeriesColumnType="Cube,Cube,Cube,Cube,Cube",
SeriesMin="default,default,default,default,default",
SeriesMax="default,default,default,default,default",
SeriesColor="#008000,#ff00ff,#000080,#993300,#000000",
SeriesFunctionMetaData="true,true,true,true,true",
ShowSeriesDataLabels="false,false,false,false,false",
LegendPosition=Top Right,
LegendWidthType=Exact,
LegendWidth=100,
LegendHeightType=Fit,
LegendHeight=160,
ShowFixedCategoryCount=false,
FixedCategoryCount=1'
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017