Jump to content
Software FX Community

Additional X-Axes in CrosstabTransformed Chart


Choyee

Recommended Posts

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:

CondtionKey

DataIndex

DataValue

ExtractTime

Place

Origin

Index1

0

2009-12-01

Level1

Origin

Index2

0.8

2009-12-01

Level1

Origin

Index3

0.6

2009-12-01

Level1

Origin

Index4

10

2009-12-01

Level1

Origin

Index5

0

2009-12-01

Level1

Origin

Index6

500

2009-12-01

Level1

Origin

Index7

500

2009-12-01

Level1

Origin

Index8

500

2009-12-01

Level1

Origin

Index9

2700

2009-12-01

Level1

Origin

Index10

2300

2009-12-01

Level1

Origin

Index11

60

2009-12-01

Level1

Origin

Index12

8

2009-12-01

Level1

Origin

Index13

29

2009-12-01

Level1

Origin

Index14

20

2009-12-01

Level1

Origin

Index15

8

2009-12-01

Level1

Origin

Index16

0

2009-12-01

Level1

Origin

Index17

34

2009-12-01

Level1

Origin

Index18

8

2009-12-01

Level1

Origin

Index19

35

2009-12-01

Level1

Origin

Index20

35

2009-12-01

Level1

1st

Index1

0

2009-12-07

Level3

1st

Index2

0.4

2009-12-07

Level3

1st

Index3

0.4

2009-12-07

Level3

1st

Index4

10

2009-12-07

Level3

1st

Index5

0

2009-12-07

Level3

1st

Index6

29

2009-12-07

Level3

1st

Index7

29

2009-12-07

Level3

1st

Index8

29

2009-12-07

Level3

1st

Index9

1800

2009-12-07

Level3

1st

Index10

1800

2009-12-07

Level3

1st

Index11

40

2009-12-07

Level3

1st

Index12

8

2009-12-07

Level3

1st

Index13

35

2009-12-07

Level3

1st

Index14

20

2009-12-07

Level3

1st

Index15

10

2009-12-07

Level3

1st

Index16

0

2009-12-07

Level3

1st

Index17

41

2009-12-07

Level3

1st

Index18

15

2009-12-07

Level3

1st

Index19

70

2009-12-07

Level3

1st

Index20

70

2009-12-07

Level3

 

 

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...