-
Notifications
You must be signed in to change notification settings - Fork 1
/
kanban-table-done.html
62 lines (46 loc) · 2.51 KB
/
kanban-table-done.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
<html>
<head>
<script type='text/javascript' src='https://www.google.com/jsapi'></script>
<script type='text/javascript'>
google.load('visualization', '1', {packages:['table']});
google.setOnLoadCallback(drawVisualization);
function drawVisualization() {
// To see the data that this visualization uses, browse to
// http://spreadsheets.google.com/ccc?key=pCQbetd-CptGXxxQIG7VFIQ
var query = new google.visualization.Query(
'https://docs.google.com/spreadsheet/ccc?key=0Aj9OVXRJH0lidEdUU0hoSW9uUkpwQVkydS1UTE9KNEE');
// Apply query language.
query.setQuery('SELECT A,D,F,G, B,H,L,S WHERE E = "Done"');
// Send the query with a callback function.
query.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
return;
}
var data = response.getDataTable();
var table = new google.visualization.Table(document.getElementById('table_div'));
var formatter = new google.visualization.ColorFormat();
formatter.addRange('App Rollout', 'DB Change', 'black', 'yellow');
formatter.addRange('DB Change', 'Data Rollout', 'white', '#70B8FF');
formatter.addRange('Data Rollout', 'Incident', 'white', '#1F5C99');
formatter.addRange('Incident', 'Sys Change', 'white', 'red');
formatter.addRange('Sys Change', null, 'white', 'green');
formatter.format(data, 2); // Apply formatter to second column
var formatterJiraTicket = new google.visualization.PatternFormat('<a href="http://myjira.com/{0}">{0}</a>');
formatterJiraTicket.format(data, [1]);
var formatterTimeDone = new google.visualization.DateFormat({pattern: "d-MMM-yyyy H:mm"});
formatterTimeDone.format(data, 6);
table.draw(data, {allowHtml: true, showRowNumber: false});
}
</script>
</head>
<body>
<h1>Places Release Kanban Board: What we delivered in 2012?</h1>
<p>All time values refer to Berlin time (MEZ = UTC+1). <strong>RCT</strong> stands for <i>Release Cycle Time</i>, that is,
the time between the start time of a release (e.g. the team created the rpm and sends the announcement) and its delivery to production.
</p>
<div id='table_div'></div>
</body>
</html>