Wow. Thanks for the help. This is exactly what I was looking for!
On Monday, July 23, 2012 10:58:09 PM UTC+3, asgallant wrote: > > Ok, so you want to pivot the data so that "Micheal", "Elisa", "Robert", > etc become the data series and "[0:1]", "[1:2]", etc are the x-axis labels, > correct? > > You can do that manually, but it takes a bit of hackery to make it work. > You have to build a new data table and draw the chart separately from the > rest of the Dashboard, from within a "ready" event handler attached to > another chart or table. See an example here: > http://jsfiddle.net/asgallant/8FavC/ > > On Monday, July 23, 2012 11:35:11 AM UTC-4, Mattan wrote: >> >> I've been digging on this for quite a while. >> >> I have a dashboard with a column chart,data table, and two filters - all >> are binded together. The code for creating the dashboard: >> >> function >> drawMainDashboard(objectID,categoryPickerID,chartID,tableID,dataArray,CatagoryObj,GroupPickerID) >> { >> var dashboard = new google.visualization.Dashboard( >> document.getElementById(objectID)); >> >> >> var table = new google.visualization.ChartWrapper({ >> 'chartType': 'Table', >> 'containerId': tableID, >> 'options': {'allowHtml': true, >> } >> }); >> >> >> var stacked = new google.visualization.ChartWrapper({ >> 'chartType': 'ColumnChart', >> 'containerId': chartID, >> 'reverseCategories':true, >> 'options': { >> 'width': 700, >> 'height': 700, >> 'isStacked': true >> }, >> 'view': {'columns': [0,2,3,4,5,6,7,8]} >> }); >> dashboard.bind([CatagoryObj,GroupPickerID], [stacked, table]); >> dashboard.draw(dataArray); >> >> } >> >> The table is given to the function as a Parameter. Here is the >> declaration of the table: >> >> var myArray =[ >> ['hier','Group', '[0:1]', '[1:2]', >> '[2:3]','[3:4]','[4:5]','[5:6]','[6:7]'], >> ['Michael','aaa', 1,2,3,4,5,6,7], >> ['Elisa','bbb', 1,2,3,4,5,6,7], >> ['Robert','ccc',1,2,3,4,5,6,7], >> ['John','ddd', 1,2,3,4,5,6,7], >> ['Jessica','aaa', 1,2,3,4,5,6,7], >> ['Aaron','aaa', 1,2,3,4,5,6,7], >> ['Margareth','aaa',1,2,3,4,5,6,7], >> ['Miranda','aaa', 1,2,3,4,5,6,7]]; >> var data = google.visualization.arrayToDataTable(myArray); >> >> The thing is that I want to display the table as I declared it. However, >> I also want the column chart's x-axis to be taken as the first row of the >> table (except the first two columns), such that the series would be the >> first column (again, without the first cell, which is the title). >> >> When I run the code, I get the opposite of what I want. >> >> Yes, I know that I can rotate the 2d array to get what I want, but I lose >> functionality (for example, the group column will have to be eliminated, >> which is no good, since I have a categoryFilter based on that). >> >> Is there a way to do so? I read the API in google Visualization, found >> nothing. >> >> Thanks! >> >> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/PoXsDIWQ95oJ. 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-visualization-api?hl=en.
