Hi, I am having some trouble in grouping some data of a table. I have a table like below:
var data = google.visualization.arrayToDataTable([ ['Config', 'Tech', 'CLK', 'Leak']', ['Config_A', '40lp', 361, 0.02]', ['Config_A', '40lp', 366, 0.025]', ['Config_A', '40lp', 53, 0.007]', ['Config_A', '65lp', 349, 0.025]', ['Config_A', '65lp', 361, 0.0345]', ['Config_A', '65lp', 48, 0.006]', ['Config_B', '40lp', 346, 0.035]', ['Config_B', '40lp', 349, 0.0403]', ['Config_B', '40lp', 51, 0.011]', ['Config_B', '65lp', 343, 0.046]', ['Config_B', '65lp', 345, 0.055]', ['Config_B', '65lp', 47, 0.01]' ]); from this kind of table, I want to group based on distinct values of column 2(CLK) and generate some table with unique columns for 'Config + Tech' combination. below is what the generated table should look like. The main reason why I want to generate this is, I want to draw a line chart of leakage power vs the CLK speed of the four columns listed in the table below. new_data = [ ['CLK', 'Config_A_40lp', 'Config_A_65lp', 'Config_B_40lp', 'Config_B_65lp'], [47, null, null, null, 0.01], [48, null, 0.006, null, null], [51, null, null, 0.011, null], [53, 0.007, null, null, null], [343, null, null, null, 0.046], [345, null, null, null, 0.055], [346, null, null, 0.035, null], [349, null, 0.025, 0.0403, null], [361, 0.02, 0.0345, null, null], [366, 0.025, null, null, null] ]; Is it possible to do this using some Google chart API, and/or Javascript? Any help would be appreciated. Thanks. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
