Do you mean table paging? Set the Table's "page" option to "enable" and
the "pageSize" option to however many rows you want shown at one time:
var table = new google.visualization.ChartWrapper({
'chartType': 'Table',
'containerId': 'TableContainer',
'options': {
'width': '900px',
page: 'enable',
pageSize: 10
}
});
On Friday, May 23, 2014 12:17:42 PM UTC-4, Missy wrote:
>
> I would like to seek advice, in their is property method in the API, which
> can code to display certain number of rows of data for line/table charts.
> Currently, my database query triggers the chart's data and it displays
> every row, but is it possible to render the chart/table to show certain
> number of rows using the javascript:
>
> function drawVisualization(dataValues, chartTitle, columnNames,
> categoryCaption) {
> if (dataValues.length < 1)
> return;
>
> var data = new google.visualization.DataTable();
> data.addColumn('string', columnNames.split(',')[0], 'name');
> data.addColumn('number', columnNames.split(',')[1], 'price');
> data.addColumn('string', columnNames.split(',')[2], 'type');
> data.addColumn('datetime', columnNames.split(',')[3], 'date');
>
> for (var i = 0; i < dataValues.length; i++) {
>
> var date = new Date(parseInt(dataValues[i].Date.substr(6),
> 10));
>
> data.addRow([dataValues[i].ColumnName,
> dataValues[i].Value, dataValues[i].Type, date]);
> }
>
> var table = new google.visualization.ChartWrapper({
> 'chartType': 'Table',
> 'containerId': 'TableContainer',
> 'options': {
> 'width': '900px'
> }
> });
>
> var categoryPicker = new
> google.visualization.ControlWrapper({
> 'controlType': 'CategoryFilter',
> 'containerId': 'control2',
> 'options': {
> 'filterColumnLabel': columnNames.split(',')[3],
> 'filterColumnIndex': '3',
>
> 'ui': {
> 'labelStacking': 'horizontal',
> 'allowTyping': false,
> 'allowMultiple': false,
> 'caption': categoryCaption,
> 'label': 'Date',
> }
> }
> });
>
> // Define a StringFilter control for the 'Name' column
> var stringFilter = new
> google.visualization.ControlWrapper({
> 'controlType': 'StringFilter',
> 'containerId': 'control1',
> 'options': {
> 'filterColumnLabel': columnNames.split(',')[0]
> }
> });
>
>
> }
>
> Please advice, if possible. Thanks in advance.
>
--
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.
