Choyee Posted January 7, 2010 Report Share Posted January 7, 2010 I'm trying to display unsorted dataset using CrosstabTransform. From what I understand, CrosstabTransform.RowPath is used as an X-Axis and ColumnPath as Serieses for the transformed chart. For example, I use following CLR object for dataset: class MyData { public string DataIndex {get; set;} public double DataValue {get; set;} public string ConditionKey {get; set;} public DateTime ExtractTime {get; set;} public string Place {get; set;} ... } It goes like this, there are fixed 20 'DataIndex' items and each 'ConditionKey' has a set of 'DataIndex' with their 'DataValue's. So, one 'ConditionKey' item has 20 'DataVlaue's and same 'Place' and 'ExtractTime'. I'm not quite sure whether I'm drawing a right picture here. Anyway, I use 'DataIndex' for the ColumnPath, 'ConditionKey' for the RowPath and 'DataValue' for the ValuePath so that it looks like each 'DataIndex' as an individulal series. It's supposed to give how each 'DataIndex' has changed its 'DataValue' for each 'ConditionKey'. So far it worked as I expected. What I've been trying to do is to display additional information like 'Place' and 'ExtractTime' as additional x-axes. Is it possible? Or, any idea? Thanks in advance. p.s. Followings are sample dataset: CondtionKeyDataIndexDataValueExtractTimePlace OriginIndex102009-12-01Level1 OriginIndex20.82009-12-01Level1 OriginIndex30.62009-12-01Level1 OriginIndex4102009-12-01Level1 OriginIndex502009-12-01Level1 OriginIndex65002009-12-01Level1 OriginIndex75002009-12-01Level1 OriginIndex85002009-12-01Level1 OriginIndex927002009-12-01Level1 OriginIndex1023002009-12-01Level1 OriginIndex11602009-12-01Level1 OriginIndex1282009-12-01Level1 OriginIndex13292009-12-01Level1 OriginIndex14202009-12-01Level1 OriginIndex1582009-12-01Level1 OriginIndex1602009-12-01Level1 OriginIndex17342009-12-01Level1 OriginIndex1882009-12-01Level1 OriginIndex19352009-12-01Level1 OriginIndex20352009-12-01Level1 1stIndex102009-12-07Level3 1stIndex20.42009-12-07Level3 1stIndex30.42009-12-07Level3 1stIndex4102009-12-07Level3 1stIndex502009-12-07Level3 1stIndex6292009-12-07Level3 1stIndex7292009-12-07Level3 1stIndex8292009-12-07Level3 1stIndex918002009-12-07Level3 1stIndex1018002009-12-07Level3 1stIndex11402009-12-07Level3 1stIndex1282009-12-07Level3 1stIndex13352009-12-07Level3 1stIndex14202009-12-07Level3 1stIndex15102009-12-07Level3 1stIndex1602009-12-07Level3 1stIndex17412009-12-07Level3 1stIndex18152009-12-07Level3 1stIndex19702009-12-07Level3 1stIndex20702009-12-07Level3 Quote Link to comment Share on other sites More sharing options...
JuanC Posted January 8, 2010 Report Share Posted January 8, 2010 Can you post an image of the chart you are getting now and annotate where would you want to see the additional information? I am afraid there might not be enough space. JuanC Quote Link to comment Share on other sites More sharing options...
Choyee Posted January 12, 2010 Author Report Share Posted January 12, 2010 I've attached a chart image file. I'd like to see the other information as x-axes. As a result, I'd like to display data change patterns for each 'DataIndex' with its related information such as 'ExtractTime' and 'Place'. Thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.