User (Legacy) Posted March 9, 2006 Report Share Posted March 9, 2006 I am trying to create a crosstab XY chart. My groups are not balanced and do not contain the same values for the X values. Even though I am using cfxCT.XValue = True it does not seem its doing a true XY with the crosstab. Specific Information below: Select Statement: select lot, months, p from table1 group by lot, months, p Result of Select: LOT MONTHS P 10A 0 102.352 10A 3 92.428 10A 6 98.923 10A 9 98.269 10A 12 100.154 10A 18 104.499 10A 24 102.681 10B 0 100.950 10B 2 100.318 10B 6 99.474 10B 9 99.665 10B 13 99.617 10B 18 98.931 10B 24 101.196 10C 0 100.417 10C 4 99.816 10C 6 101.354 10C 9 100.076 10C 15 99.610 10C 18 100.459 10C 24 100.108 40A 1 97.722 40A 3 97.140 40A 6 96.239 40A 9 112.926 40A 12 95.082 40A 17 95.353 40A 23 96.085 40B 0 97.885 40B 3 94.650 40B 6 95.356 40B 9 95.206 40B 12 95.265 40B 18 77.980 CrossTab Setup Dim dt As SoftwareFX.ChartFX.Data.DataTableProvider dt = New SoftwareFX.ChartFX.Data.DataTableProvider dt.DataTable = DS.Tables(0) Dim cfxCT As SoftwareFX.ChartFX.Data.CrosstabDataProvider cfxCT = New SoftwareFX.ChartFX.Data.CrosstabDataProvider cfxCT.DataType(0) = SoftwareFX.ChartFX.Data.CrosstabDataType.ColumnHeading (Lot) cfxCT.DataType(1) = SoftwareFX.ChartFX.Data.CrosstabDataType.RowHeading (Months) cfxCT.DataType(2) = SoftwareFX.ChartFX.Data.CrosstabDataType.Value (p) cfxCT.XValue = True cfxCT.DataSource = dt Chart1.DataSourceSettings.DataSource = cfxCT What I am seeing: 10B, 10C, 40A I am seeing breaks and out of order points. Here is how the data appears in the data editor. I see the labels are set from the first series read then points outside of that series appear to the right with no label. When it plots it is still causing breakpoints between skipped spaces and plotting points out of order. Attempt 2: Now if I switch my select statement around and do: Select months, p, lot from stars_simple where byv='by1' group by months, p, lot And use cfxCT.DataType(2) = SoftwareFX.ChartFX.Data.CrosstabDataType.ColumnHeading cfxCT.DataType(0) = SoftwareFX.ChartFX.Data.CrosstabDataType.RowHeading cfxCT.DataType(1) = SoftwareFX.ChartFX.Data.CrosstabDataType.Value cfxCT.XValue = True I see this: With data that looks like this: The order looks good here, but I am still getting breaks between non-contiguous points. How can I get this plot to include connected points for each series? Thanks for any help. Link to comment Share on other sites More sharing options...
User (Legacy) Posted March 29, 2006 Author Report Share Posted March 29, 2006 Any help with this would be greatly appreciated. If the problem is not clear I can try and detail it better. ( It looked better on my copy, I didn't realize it would put all attachments to the bottom of the page) Synopsis, I am doing a crosstab and trying to get a true XY Line plot with no breaks between points. "Russ Hirneisen" <russh@patmedia.net> wrote in message news:IhCyRb%23QGHA.3992@webserver3.softwarefx.com... >I am trying to create a crosstab XY chart. My groups are not balanced and >do not contain the same values for the X values. Even though I am using >cfxCT.XValue = True it does not seem its doing a true XY with the crosstab. > > > > Specific Information below: > > > > Select Statement: select lot, months, p from table1 group by lot, months, > p > > > > Result of Select: > > LOT > MONTHS > P > > 10A > 0 > 102.352 > > 10A > 3 > 92.428 > > 10A > 6 > 98.923 > > 10A > 9 > 98.269 > > 10A > 12 > 100.154 > > 10A > 18 > 104.499 > > 10A > 24 > 102.681 > > 10B > 0 > 100.950 > > 10B > 2 > 100.318 > > 10B > 6 > 99.474 > > 10B > 9 > 99.665 > > 10B > 13 > 99.617 > > 10B > 18 > 98.931 > > 10B > 24 > 101.196 > > 10C > 0 > 100.417 > > 10C > 4 > 99.816 > > 10C > 6 > 101.354 > > 10C > 9 > 100.076 > > 10C > 15 > 99.610 > > 10C > 18 > 100.459 > > 10C > 24 > 100.108 > > 40A > 1 > 97.722 > > 40A > 3 > 97.140 > > 40A > 6 > 96.239 > > 40A > 9 > 112.926 > > 40A > 12 > 95.082 > > 40A > 17 > 95.353 > > 40A > 23 > 96.085 > > 40B > 0 > 97.885 > > 40B > 3 > 94.650 > > 40B > 6 > 95.356 > > 40B > 9 > 95.206 > > 40B > 12 > 95.265 > > 40B > 18 > 77.980 > > > > > CrossTab Setup > > > > Dim dt As SoftwareFX.ChartFX.Data.DataTableProvider > > dt = New SoftwareFX.ChartFX.Data.DataTableProvider > > dt.DataTable = DS.Tables(0) > > > > Dim cfxCT As SoftwareFX.ChartFX.Data.CrosstabDataProvider > > cfxCT = New SoftwareFX.ChartFX.Data.CrosstabDataProvider > > > > > > cfxCT.DataType(0) = SoftwareFX.ChartFX.Data.CrosstabDataType.ColumnHeading > (Lot) > > cfxCT.DataType(1) = SoftwareFX.ChartFX.Data.CrosstabDataType.RowHeading > (Months) > > cfxCT.DataType(2) = SoftwareFX.ChartFX.Data.CrosstabDataType.Value (p) > > cfxCT.XValue = True > > > > cfxCT.DataSource = dt > > Chart1.DataSourceSettings.DataSource = cfxCT > > > > What I am seeing: > > > > 10B, 10C, 40A I am seeing breaks and out of order points. > > > > > > > > Here is how the data appears in the data editor. I see the labels are set > from the first series read then points outside of that series appear to > the right with no label. When it plots it is still causing breakpoints > between skipped spaces and plotting points out of order. > > > > > > > > Attempt 2: > > > > Now if I switch my select statement around and do: > > > > Select months, p, lot from stars_simple where byv='by1' group by months, > p, lot > > > > And use > > > > cfxCT.DataType(2) = SoftwareFX.ChartFX.Data.CrosstabDataType.ColumnHeading > > cfxCT.DataType(0) = SoftwareFX.ChartFX.Data.CrosstabDataType.RowHeading > > cfxCT.DataType(1) = SoftwareFX.ChartFX.Data.CrosstabDataType.Value > > cfxCT.XValue = True > > > > I see this: > > > > > > > > With data that looks like this: > > > > > > > > The order looks good here, but I am still getting breaks between > non-contiguous points. How can I get this plot to include connected points > for each series? > > > > Thanks for any help. > > > > > > > > > Link to comment Share on other sites More sharing options...
User (Legacy) Posted April 3, 2006 Author Report Share Posted April 3, 2006 I am having a similar issue. Has there been an answer to this question? Please post the answer. Bob "Russ Hirneisen" <russh@patmedia.net> wrote in message news:Ppnqg6zUGHA.3544@webserver3.softwarefx.com... > Any help with this would be greatly appreciated. If the problem is not > clear I can try and detail it better. ( It looked better on my copy, I > didn't realize it would put all attachments to the bottom of the page) > > Synopsis, I am doing a crosstab and trying to get a true XY Line plot with > no breaks between points. > > > "Russ Hirneisen" <russh@patmedia.net> wrote in message > news:IhCyRb%23QGHA.3992@webserver3.softwarefx.com... >>I am trying to create a crosstab XY chart. My groups are not balanced and >>do not contain the same values for the X values. Even though I am using >>cfxCT.XValue = True it does not seem its doing a true XY with the >>crosstab. >> >> >> >> Specific Information below: >> >> >> >> Select Statement: select lot, months, p from table1 group by lot, months, >> p >> >> >> >> Result of Select: >> >> LOT >> MONTHS >> P >> >> 10A >> 0 >> 102.352 >> >> 10A >> 3 >> 92.428 >> >> 10A >> 6 >> 98.923 >> >> 10A >> 9 >> 98.269 >> >> 10A >> 12 >> 100.154 >> >> 10A >> 18 >> 104.499 >> >> 10A >> 24 >> 102.681 >> >> 10B >> 0 >> 100.950 >> >> 10B >> 2 >> 100.318 >> >> 10B >> 6 >> 99.474 >> >> 10B >> 9 >> 99.665 >> >> 10B >> 13 >> 99.617 >> >> 10B >> 18 >> 98.931 >> >> 10B >> 24 >> 101.196 >> >> 10C >> 0 >> 100.417 >> >> 10C >> 4 >> 99.816 >> >> 10C >> 6 >> 101.354 >> >> 10C >> 9 >> 100.076 >> >> 10C >> 15 >> 99.610 >> >> 10C >> 18 >> 100.459 >> >> 10C >> 24 >> 100.108 >> >> 40A >> 1 >> 97.722 >> >> 40A >> 3 >> 97.140 >> >> 40A >> 6 >> 96.239 >> >> 40A >> 9 >> 112.926 >> >> 40A >> 12 >> 95.082 >> >> 40A >> 17 >> 95.353 >> >> 40A >> 23 >> 96.085 >> >> 40B >> 0 >> 97.885 >> >> 40B >> 3 >> 94.650 >> >> 40B >> 6 >> 95.356 >> >> 40B >> 9 >> 95.206 >> >> 40B >> 12 >> 95.265 >> >> 40B >> 18 >> 77.980 >> >> >> >> >> CrossTab Setup >> >> >> >> Dim dt As SoftwareFX.ChartFX.Data.DataTableProvider >> >> dt = New SoftwareFX.ChartFX.Data.DataTableProvider >> >> dt.DataTable = DS.Tables(0) >> >> >> >> Dim cfxCT As SoftwareFX.ChartFX.Data.CrosstabDataProvider >> >> cfxCT = New SoftwareFX.ChartFX.Data.CrosstabDataProvider >> >> >> >> >> >> cfxCT.DataType(0) = >> SoftwareFX.ChartFX.Data.CrosstabDataType.ColumnHeading (Lot) >> >> cfxCT.DataType(1) = SoftwareFX.ChartFX.Data.CrosstabDataType.RowHeading >> (Months) >> >> cfxCT.DataType(2) = SoftwareFX.ChartFX.Data.CrosstabDataType.Value (p) >> >> cfxCT.XValue = True >> >> >> >> cfxCT.DataSource = dt >> >> Chart1.DataSourceSettings.DataSource = cfxCT >> >> >> >> What I am seeing: >> >> >> >> 10B, 10C, 40A I am seeing breaks and out of order points. >> >> >> >> >> >> >> >> Here is how the data appears in the data editor. I see the labels are set >> from the first series read then points outside of that series appear to >> the right with no label. When it plots it is still causing breakpoints >> between skipped spaces and plotting points out of order. >> >> >> >> >> >> >> >> Attempt 2: >> >> >> >> Now if I switch my select statement around and do: >> >> >> >> Select months, p, lot from stars_simple where byv='by1' group by months, >> p, lot >> >> >> >> And use >> >> >> >> cfxCT.DataType(2) = >> SoftwareFX.ChartFX.Data.CrosstabDataType.ColumnHeading >> >> cfxCT.DataType(0) = SoftwareFX.ChartFX.Data.CrosstabDataType.RowHeading >> >> cfxCT.DataType(1) = SoftwareFX.ChartFX.Data.CrosstabDataType.Value >> >> cfxCT.XValue = True >> >> >> >> I see this: >> >> >> >> >> >> >> >> With data that looks like this: >> >> >> >> >> >> >> >> The order looks good here, but I am still getting breaks between >> non-contiguous points. How can I get this plot to include connected >> points for each series? >> >> >> >> Thanks for any help. >> >> >> >> >> >> >> >> >> > > Link to comment Share on other sites More sharing options...
Software FX Posted April 20, 2006 Report Share Posted April 20, 2006 It took me a while to realize that what you are looking for is not supported by the CrossTab data provider. The Cross-Tab data provider treats the X-Values as discrete values, meaning that it will try to group points that have the same x-value. This is normally used for types such as dates. What you need is that there is no grouping but that points are added to the chart independently for each group (series). We are currently developing this new feature and it will be included in the next service pack. Thank you for your feedback. -- Francisco Padron www.chartfx.com Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.