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
| CSV( file("https://docs.machbase.com/assets/example/life-expectancy-table.csv") )
DROP(1) // skip header line
// | 0 1 2 3 4
// +-> income life expectancy population Country Year
// |
POPVALUE(1,2)
// | 0 1 2
// +-> income Country Year
// |
FILTER( value(1) in ("Germany", "France") )
// | 0 1 2
// +-> income Country Year
// |
MAPVALUE(0, parseFloat(value(0)))
// | 0 1 2
// +-> income Country Year
// |
GROUP(
by(value(2)),
max(value(0), where( value(1) == "Germany" )),
max(value(0), where( value(1) == "France" ))
)
// | 0 1 2
// +-> Year Germany-income France-income
// |
CHART(
chartOption({
xAxis: { name: "Year", type: "category", data: column(0) },
yAxis: { name: "Income"},
legend: { show: true },
tooltip: {
trigger: "axis",
formatter:"{b}<br/> {a0}:{c0}<br/> {a1}:{c1}"
},
series: [
{
type: "line",
name: "Germany",
showSymbol: false,
data: column(1),
tooltip: ["income"]
},
{
type: "line",
name: "France",
showSymbol: false,
data: column(2),
tooltip: ["income"]
}
]
})
)
|