Multiple Controls different datatable

by forssux

HTML

Before manual pivot:
<div id="table1"></div>After manual pivot:
<div id="table2"></div>
<script type="text/javascript" src="http://www.google.com/jsapi">
    
</script>
<body style="font-family: Arial;border: 0 none;"></body>
    <div id="dashboard">  </div>
        <tr style='vertical-align: top'>
            <td style='width: 300px; font-size: 0.9em;'>
                <div id="control1"></div>
                <div id="control2"></div>
                <!-- <div id="control3" style="display:none"></div> -->
                <div id="control3" style></div>
            </td>
            <div style="float: left;" id="chart1"></div>
            <div style="float: left;" id="chart2"></div>
            <div id="dashboard1">    </div>
            <div id="dashboard2">    </div>
            <div style="float: left;" id="chart3"></div>
            <div style="float: left;" id="chart4"></div>

JavaScript

google.load('visualization', '1.1', {
    packages: ['controls', 'table']
});

function drawVisualization() {

    // Prepare the data
    var data1 = google.visualization.arrayToDataTable([
        ['TimeStamp', 'Name', 'IngName', 'Level', 'DateStarted', 'Region'],
        ['20140101', 'Guy', 'Forssux', 14, '20130101', 'Antwerp'],
        ['20140102', 'Bart', 'MisterB', 11, '20120101', 'Antwerp'],
        ['20140103', 'Elu', 'Fly', 10, '20130201', 'Antwerp'],
        ['20140104', 'Lilie', 'WSHere', 8, '20130401', 'Antwerp'],
        ['20140105', 'Maaike', 'Neutster', 7, '20130501', 'Antwerp'],
        ['20140106', 'Peter', 'erazer', 14, '20130601', 'Antwerp'],
        ['20140107', 'Gunther', 'TheBeast', 14, '20121101', 'Antwerp'],
        ['20140108', 'Fred', 'scp4ever', 16, '20150101', 'Antwerp']
    ]);

    var data = google.visualization.arrayToDataTable([
        ['TimeStamp', 'IngName', 'Value'],
        ['20140101', 'Forssux', 123000],
        ['20140102', 'Forssux', 223000],
        ['20140103', 'Forssux', 253000],
        ['20140104', 'Forssux', 333000],
        ['20140115', 'Forssux', 443000],
        ['20140116', 'Forssux', 523000],
        ['20140127', 'Forssux', 623000],
        ['20140208', 'Forssux', 1123000],
        ['20140110', 'scp4ever', 123000],
        ['20140112', 'scp4ever', 223000],
        ['20140113', 'scp4ever', 253000],
        ['20140114', 'scp4ever', 333000],
        ['20140115', 'scp4ever', 443000],
        ['20140116', 'scp4ever', 523000],
        ['20140117', 'scp4ever', 623000],
        ['20140118', 'scp4ever', 1123000],
        ['20140101', 'TheBeast', 123000],
        ['20140102', 'TheBeast', 223000],
        ['20140103', 'TheBeast', 253000],
        ['20140114', 'TheBeast', 333000],
        ['20140120', 'TheBeast', 443000],
        ['20140126', 'TheBeast', 523000],
        ['20140127', 'TheBeast', 623000],
        ['20140128', 'TheBeast', 1123000]

    ]);

    var distinctValues = data.getDistinctValues(1);
    var...