** n00b alert ** I have a DataTable that contains:
id day proj col1 col2 subtype time 1 Nov 28 projectA 1050 880 foo 17481 2 Nov 28 projectA 1050 880 bar 16098 3 Nov 28 projectA 1080 40 foo 13509 4 Nov 28 projectA 1080 40 bar 9031 But would like to create a new pivoted DataView containing: id day proj col1 col2 foo bar 1 Nov 28 projectA 1050 880 17481 16098 3 Nov 28 projectA 1080 40 13509 9031 Which I'd then like to create a stacked columnChart for. There's a pivot clause in the query language, but how do I pivot data already in a DataTable? -- You received this message because you are subscribed to the Google Groups "Google Chart API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-chart-api/-/fRisWHHKy78J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-chart-api?hl=en.
