Both Sort and Filter View

[AM]

Is there a way to both sort and filter the data in a view?


    var view18 = new google.visualization.DataView(dt);
    view18.setRows(dt.getFilteredRows([{'column': 2, 'value': 'Male'}]));
    view18.setRows(dt.getSortedRows(3));
    Chart18.setDataTable(view18);
    Chart18.draw();

I'm finding that this only allows for the the filter.

[Andrew Gallant]

You can do this with a single view; you need to get the sorted rows from the view and then translate them back into the table row indices.

var view18 = new google.visualization.DataView(dt);
view18.setRows(

dt.getFilteredRows([{'column': 2, 'value': 'Male'}]));
var sortedViewRows = view18.getSortedRows(3);
var sortedTableRows = [];
for (var i = 0; i < sortedViewRows.length; i++) {
    sortedTableRows.push(view18.getTableRowIndex(sortedViewRows[i]));
}
view18.setRows(sortedTableRows);

Using two views makes for cleaner code, though:

var filterView = new google.visualization.DataView(dt);
filterView.setRows(dt.getFilteredRows([{'column': 2, 'value': 'Male'}]));
var view18 = new google.visualization.DataView(filterView);
view18.setRows(filterView.getSortedRows(3));

[AM]

This was very very helpful.  Thanks much Andrew!

[AM]

What if I needed to filter the data for the first chart?

If I already have that chart in in the dashboard initialization:

var dashboard = new google.visualization.Dashboard(document.getElementById('chart_div1')).bind([categoryPicker1],[Chart1,Chart4]).draw(data1);

I can't then do this procedure of creating new views based on the first table.  I would need to filter it first before that dashboard draw?

Would I just do a temp variable like var view1?

Thanks for any feedback.

[Andrew Gallant]

I would create a DataView based on your original DataTable, and sort that.  The pass the view to the Dashboard instead of the DataTable.