2 <script type="text/javascript" src="//www.google.com/jsapi"></script>
3 <link rel="stylesheet" href="/static/hpc_historical.css">
4 <script type="text/javascript">
5 google.load('visualization', '1', {'packages' : ['controls','table','corechart','geochart']});
8 <script type="text/javascript">
13 showRowNumber: false,
\r
16 backgroundColor: "black"
\r
19 // ask django for a data source URL to use for the graphs
\r
21 function updateDataSourceUrl() {
\r
22 var sliceName = $("#historical_slicename :selected").text();
\r
23 var queryString = "/analytics/bigquery/?sum=@bytes_sent&avg=@cpu&groupBy=Time,city,@hostname,@site&slice=" + sliceName;
\r
29 success: function (newData) {
\r
30 sendAndDraw(newData["dataSourceUrl"])
\r
42 google.setOnLoadCallback(function () {
\r
43 $('#historical_slicename').change(function()
\r
45 updateDataSourceUrl();
\r
48 updateDataSourceUrl();
\r
51 function showSiteTimeAgg(dt) {
\r
52 var lineChart = new google.visualization.ChartWrapper({
\r
53 'chartType': 'LineChart',
\r
54 'containerId': 'chart4',
\r
58 'title': 'Network-wide usage',
\r
63 'columns': [0, 1, 2]
\r
66 lineChart.setDataTable(dt);
\r
70 function showSiteAgg(dt) {
\r
71 var barChart = new google.visualization.ChartWrapper({
\r
72 'chartType': 'ColumnChart',
\r
73 'containerId': 'chart1',
\r
77 'title': 'Site-wise usage',
\r
82 'columns': [1, 2, 3]
\r
85 barChart.setDataTable(dt);
\r
87 var geoChart = new google.visualization.ChartWrapper({
\r
88 'chartType': 'GeoChart',
\r
89 'containerId': 'chart2',
\r
93 'displayMode': 'markers',
\r
95 'title': 'Usage map',
\r
97 colors: ['green', 'purple', 'red']
\r
101 'columns': [0, 2, 3]
\r
104 geoChart.setDataTable(dt);
\r
107 var histogram = new google.visualization.ChartWrapper({
\r
108 'chartType': 'Histogram',
\r
109 'containerId': 'chart6',
\r
114 'title': 'Sites by load',
\r
119 histogram.setDataTable(dt);
\r
124 function handleResponse(response) {
\r
125 var timeSlider = new google.visualization.ControlWrapper({
\r
126 'controlType': 'DateRangeFilter',
\r
127 'containerId': 'control1',
\r
129 'filterColumnLabel': 'Time',
\r
137 // Define a bar chart
\r
138 var barChart = new google.visualization.ChartWrapper({
\r
139 'chartType': 'BarChart',
\r
140 'containerId': 'chart1',
\r
156 var categoryPicker = new google.visualization.ControlWrapper({
\r
157 'controlType': 'CategoryFilter',
\r
158 'allowMultiple': true,
\r
159 'containerId': 'control2',
\r
161 'filterColumnLabel': 'site',
\r
163 'labelStacking': 'vertical',
\r
164 'allowTyping': false
\r
169 var proxy = new google.visualization.ChartWrapper({
\r
170 'chartType': 'Table',
\r
171 'containerId': 'chart7',
\r
181 'columns': [0, 1, 2, 3, 4, 5]
\r
185 function avg_bandwidth(arr) {
\r
187 for (var i = 0; i < arr.length; i++) {
188 ret+=arr[i]*8.0/1024.0/1024.0/1024.0;
193 return ret/arr.length;
196 function sum_bytes_sent_as_bw(arr) {
\r
198 for (var i = 0; i < arr.length; i++) {
199 ret+=arr[i]*8.0/1024.0/1024.0/1024.0;
204 function sum_bytes_sent_as_GB(arr) {
\r
206 for (var i = 0; i < arr.length; i++) {
207 ret+=arr[i]/1024.0/1024.0/1024.0;
212 function fixDate2(unixDate) {
\r
213 // not completely sure why we have to do this, as the data was in
\r
214 // javascript Date() objects to start with. If we don't do it,
\r
215 // then the horizontal axis will be blank.
\r
216 return new Date(unixDate);
219 var format0dp = new google.visualization.NumberFormat({fractionDigits:0});
\r
220 var format2dp = new google.visualization.NumberFormat({fractionDigits:2});
\r
222 // Create a group for charts that will have a horizontal axis that is
\r
225 google.visualization.events.addListener(proxy, 'ready', function () {
\r
226 var dt = proxy.getDataTable();
\r
227 var groupedData1 = google.visualization.data.group(dt, [{
\r
235 aggregation: google.visualization.data.avg
\r
237 column: BANDWIDTH_COL,
\r
240 aggregation: sum_bytes_sent_as_bw
\r
243 format0dp.format(groupedData1,1);
\r
244 format2dp.format(groupedData1,2);
\r
246 showSiteTimeAgg(groupedData1);
\r
249 // Create a group for charts that will have a horizontal axis that is
\r
252 google.visualization.events.addListener(proxy, 'ready', function () {
\r
253 var dt = proxy.getDataTable();
\r
254 var groupedData0 = google.visualization.data.group(dt, [CITY_COL, SITE_COL], [{
\r
258 aggregation: google.visualization.data.avg
\r
260 column: BANDWIDTH_COL,
\r
263 aggregation: sum_bytes_sent_as_GB
\r
266 format0dp.format(groupedData0,2);
\r
267 format2dp.format(groupedData0,3);
\r
269 showSiteAgg(groupedData0);
\r
272 data = response.getDataTable();
\r
273 new google.visualization.Dashboard(document.getElementById('dashboard')).
\r
274 // Establish bindings, declaring the both the slider and the category
\r
275 // picker will drive both charts.
\r
276 bind([categoryPicker, timeSlider], [proxy]).
\r
277 // Draw the entire dashboard.
\r
282 function sendAndDraw(queryString) {
\r
283 query = new google.visualization.Query(queryString)
\r
284 query && query.abort();
\r
285 query.send(function (response) {
\r
286 handleResponse(response);
\r
291 <div id="dashboard" class="container">
293 <span><b>Slice Name:</b></span>
294 <span><select id="historical_slicename">
295 {% for slice in userSliceInfo %}
296 <option value="{{ slice.slicename }}">{{ slice.slicename }}</option>
301 <div class="col-md-8">
302 <div class="col-md-4" id="control2"></div>
303 <div class="col-md-4" id="control1"></div>
304 <!--<div class="col-md-4" id="control3"></div>-->
308 <div class="col-md-8">
309 <div class="col-md-4" id="chart1">
311 <div class="col-md-4" id="chart2">
314 <div class="col-md-4" id="chart3">
319 <div class="col-md-8">
320 <div class="col-md-4" id="chart4">
323 <div class="col-md-4" id="chart5">
325 <div class="col-md-4" id="chart6">
330 <div id="chart7" style="display:none"></div>