Look at the Chart.png.
ADS is saying the slope in 1.27273, but the correct slope for the data is 1.
Y intercept should be 0, but ADS is saying .54
ADS does correctly calculate if I specify 0,0,2 as shown in Series.png
To reproduce the issue, execute the below SQL. A chart will be created w/ the incorrect slope & y intercept values.
=======
create table test
(x_value int,
y_value int)
go
insert test values (1,1)
insert test values (2,2)
insert test values (3,3)
go
select * from test
go
.setResultSettings 'Index=1,
CategoryFields="[x_value]",
SeriesFields="[y_value]",
ShowChart=true,
ShowToolbar=true,
Paging=true,
Split=300,
Chart="{column,line}",
Theme=default,
RotX=325,
RotY=0,
RotZ=0,
ZoomScalar=1.0,
ShowLegend=true,
ShowLegendBorder=true,
ShowGrid=true,
FillGrid=true,
GridOpacity=0.5,
GridLineWidth=1.0,
Title="",
TitlePosition="Bottom Center",
TitleCategory="",
TitleValue="",
UseTitleMargin=false,
UseAxisTitleMargin=false,
AxisTitleOnEdge=false,
PieExplode=0.0,
GroupSmallValues=true,
SmallValuesThreshold=3.0,
PieLabelDistance=3.0,
PieShowLines=false,
PieShowValues=false,
LineWidth=1.0,
ShowMarkers=true,
MapShowBackground=false,
MapShowDetails=false,
MapRange="",
MapRangeColors="",
Width=16.0,
Height=10.0,
Depth=5.0,
SeriesSpacing=1.0,
CategorySpacing=1.0,
Font=Arial-PLAIN-10,
FontTitle=Times New Roman-BOLD-16,
LegendFontSize=1.0,
SeriesFontSize=1.0,
CategoryFontSize=1.0,
ValueFontSize=1.0,
TitleFontSize=1.75,
AxisTitleFontSize=1.25,
DataLabelFontSize=1.0,
TopColor=#ebf0f5,
BottomColor=#d7dcf5,
PanX=0.0,
PanY=0.0,
Lighting=Default,
Opacity=1.0,
View2D=true,
FitChartToImage=false,
StackedPercent=false,
ShowValueAxis=true,
ShowValueAxisTicks=true,
ShowValueAxisLines=false,
ReverseValueAxis=false,
ShowCategoryAxis=true,
ShowCategoryAxisTicks=true,
ShowCategoryAxisLines=true,
ShowSeriesAxis=true,
ShowDataLabels=false,
ValueAxisNumberFormat="",
CategoryAxisNumberFormat="",
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="default,default",
SeriesFunctionMetaData="true,true",
ShowSeriesDataLabels="false,false",
LegendPosition=Top Right,
LegendWidthType=Fit,
LegendWidth=100,
LegendHeightType=Fit,
LegendHeight=160,
UseLegendMargin=false,
ShowFixedCategoryCount=false,
FixedCategoryCount=0'
@sachin:
For script above, the NumericCategoryAxis parameter is false, so the x axis is treated as dimension rather than numeric values.