3D Bar with Dataset

 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

CSV( file("https://docs.machbase.com/assets/example/life-expectancy-table.csv") )
// |   0        1                 2            3        4
// +-> income   life-expectancy   population   country  year
// |
DROP(1) // drop header
// |
MAPVALUE(0, value(4))
// |   0        1                 2            3        4
// +-> year     life-expectancy   population   country  year
// |
POPVALUE(4)
// |   0        1                 2            3
// +-> year     life-expectancy   population   country
// |
MAPVALUE(1, parseFloat(value(1)) )
MAPVALUE(2, parseFloat(value(2)) )
// |   0        1                 2            3 
// +-> year     life-expectancy   population   country
// |
MAPVALUE(0, list(value(0), value(1), value(2), value(3)))
POPVALUE(1,2,3)
// |   0 
// +-> [year, life-expectancy, population, country]
// |
CHART(
    plugins("gl"),
    chartOption({
        grid3D: {},
        tooltip: {},
        xAxis3D: { type: "category" },
        yAxis3D: { type: "category" },
        zAxis3D: {},
        visualMap: { max: 100000000, dimension: "Population"},
        dataset: {
            dimensions: [
                { name: "Year", type: "ordinal"},
                "Life Expectancy",
                "Population",
                "Country"
            ],
            source: column(0)
        },
        series: [
            {
                type: "bar3D",
                shading: "lambert",
                encode: {
                    x: "Year",
                    y: "Country",
                    z: "Lefe Expectancy",
                    tooltip: [0, 1, 2, 3]
                }
            }
        ]
    })
)