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/-/ivo98s2UMu0J.
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.
