/
index.html
111 lines (90 loc) · 2.9 KB
/
index.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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
---
layout: default
text: 'Inicio'
title: 'Inicio'
---
{{site.locales[locale]}}
<div class="row spacebottom">
<div class="large-12 columns">
{% include editables/start/inicio.html %}
</div>
</div>
<div class="row spacetop">
<div class="large-12 columns">
{% include editables/start/cobertura-del-estudio.html %}
<div id="companies-vs-studies-bar-chart"> </div>
</div>
</div>
<div class="row spacetop">
<div class="large-12 columns">
{% include editables/start/ingresos.html %}
<div id="companies-government-diff"> </div>
</div>
</div>
<div class='row spacetop'>
<div class='large-6 columns'>
{% include editables/start/participacion.html %}
</div>
<div class='large-6 columns'>
<div id="aggregation-pie-chart"> </div>
<ul class='years download'>
<li class='year-toggle'>
<a class='json-empresas' href='' target='_blank'>JSON</a>
</li>
<li class='year-toggle'>
<a class='csv-empresas' href='' target='_blank'>CSV</a>
</li>
</ul>
</div>
</div>
<script>/*<![CDATA[*/
google.load("visualization", "1", {packages:["corechart"]});
$(document).ready(function() {
GChart.chain(['first','second','third'], function(dataTable){
GDataTable.col(dataTable, 0,
['Primer Estudio', 'Segundo Estudio', 'Tercer Estudio']);
var options = {legend: {position: 'bottom'}};
GChart.draw('companies-vs-studies-bar-chart', dataTable, 'ColumnChart',
options);
});
GChart.dataTable('colDiff', function(dataTable){
// Columns
var year = 0, currency = 1, gov = 2, comp = 3;
var options = {
legend: { position: 'right' },
chartArea: {top: 20, width: 600}
};
GDataTable.map(dataTable, function(row){
var _year = row[year];
var isUsd = row[currency] == 'USD';
return [ _year, row[currency],
isUsd ? row[gov].toSol(_year) : row[gov],
isUsd ? row[comp].toSol(_year) : row[comp]
];
});
var sum = function(column){
var _sum = google.visualization.data.sum;
return {'column': column, 'aggregation': _sum, 'type': 'number'};
};
// Remove currency column and group by currency
dataTable = google.visualization.data.group(dataTable, [year],
[sum(gov), sum(comp)]
);
GChart.format(dataTable, [gov - 1 , comp - 1]);
GChart.draw('companies-government-diff', dataTable, 'ColumnChart',
options);
});
GChart.dataTable('companiesByAggregation', function(aggregations){
GChart.format(aggregations, [1]);
var id = 'aggregation-pie-chart';
var width = '150%';
var height = '150%';
GChart.charts.pie(id, aggregations, width, height);
});
// URLs for pie chart links
GSpreadsheet.sheetByTitle('empresas', function(id){
$('.json-empresas').attr('href', GSpreadsheet.sheetUrl(id) + "?alt=json");
});
$('.csv-empresas' ).attr('href', GSpreadsheet.csvUrl('empresas'));
});/*]]>*/</script>
{% include treemap.html %}