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
829
|
-------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 3D Column Cluster 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, 35 as s2
union
select 2 as category, 45 as s1, 55 as s2
union
select 3 as category, 80 as s1, 90 as s2
union
select 4 as category, 20 as s1, 45 as s2
union
select 5 as category, 65 as s1, 85 as s2
union
select 6 as category, 40 as s1, 60 as s2
GO
.setResultSettings 'Index=1,
CategoryFields="[category]",
SeriesFields="[s2],[s1]",
ShowChart=true,
ShowToolbar=true,
Paging=true,
Split=300,
Chart="{columncluster,columncluster}",
RotX=324,
RotY=-23,
RotZ=0,
Zoom=17.606081,
ScaleData=true,
ShowLegend=true,
ShowGrid=true,
Title="3D Column Cluster Chart",
PieExplode=0.0,
GroupSmallValues=true,
SmallValuesThreshold=3.0,
PieLabelDistance=3.0,
PieShowLines=false,
LineWidth=1.0,
Width=16.0,
Height=10.0,
Depth=4.0,
SeriesSpacing=0.45,
CategorySpacing=0.45,
Font="Arial-6",
TopColor="#D7DCF5",
BottomColor="#EBF0F5",
PanX=-9.599992,
PanY=-3.8999996,
Lighting=Default,
View2D=false,
StackedPercent=false,
ShowValueAxis=true,
ShowCategoryAxis=true,
ShowSeriesAxis=false,
ValueAxisNumberFormat="###0",
CategoryAxisNumberFormat="#,##0",
NumericCategoryAxis=false,
MergeAxis=false,
SeriesAlias="default,default",
SeriesSubType=",",
SeriesColumnType="Cube,Cube",
SeriesMin="default,default",
SeriesMax="default,default",
SeriesColor="#3366FF,default",
SeriesFunctionMetaData="true,true",
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