Hi everyone,
In the following JSON:
var data = new google.visualization.DataTable(
{
cols: [{id: 'Option1', label: 'Manufacturer', type:
'string'},
{id: 'Option2', label: 'Region', type:
'string'},
{id: 'Option3', label: 'Option3', type:
'number'},
{id: 'Option4', label: 'Option4', type:
'number'},
{id: 'Option5', label: 'Option5', type:
'number'},
{id: 'Option6', label: 'Option6', type:
'number'},
{id: 'Option7', label: 'Option7', type:
'number'},
{id: 'Option8', label: 'Option8', type:
'number'}],
rows: [{c:[{v: 'Ford'}, {v: 'South East'}, {v: 2}, {v:
3}, {v: 4}, {v: 5}, {v: 6}, {v: 7}]},
{c:[{v: 'Ford'}, {v: 'South East'}, {v: 2},
{v: 3}, {v: 4}, {v: 5}, {v: 6}, {v: 7}]},
{c:[{v: 'Ford'}, {v: 'South East'}, {v: 2},
{v: 3}, {v: 4}, {v: 5}, {v: 6}, {v: 7}]},
{c:[{v: 'BMW'}, {v: 'South East'}, {v: 2}, {v:
3}, {v: 4}, {v: 5}, {v: 6}, {v: 7}]},
{c:[{v: 'BMW'}, {v: 'North'}, {v: 2}, {v: 3},
{v: 4}, {v: 5}, {v: 6}, {v: 7}]},
{c:[{v: 'BMW'}, {v: 'North'}, {v: 2}, {v: 3},
{v: 4}, {v: 5}, {v: 6}, {v: 7}]},
{c:[{v: 'Citroen'}, {v: 'North'}, {v: 2}, {v:
3}, {v: 4}, {v: 5}, {v: 6}, {v: 7}]},
{c:[{v: 'Citroen'}, {v: 'South East'}, {v: 2},
{v: 3}, {v: 4}, {v: 5}, {v: 6}, {v: 7}]}
]
},
0.6
)
my graph 'will' display the manufacturers as rows with 7 bars of data
against each.
I want to be able to filter the data using a dependent control in
order to see just the rows in each region (column 1).
At the current time this graph does not draw because the region column
is not a integer and so it cannot be displayed.
Therefore I want to 'hide' the region column so that it is not
displayed as a bar, but is available for use with the dependent
control.
Can anyone help with this as I cannot find any way to do it? I don't
think that the hideColumns method will work because that removes the
column from the data object and there3fore the dependent control
cannot see it.
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
