Air Passengers
CSV (file("https://docs.machbase.com/assets/example/AirPassengers.csv"))
// drop header : rownames,time,value
DROP(1)
// drop rownames column
POPVALUE(0)
// year float to "year/month"
MAPVALUE(0,
strSprintf("%.f/%.f",
floor(parseFloat(value(0))),
1+round(12 * (mod(round(parseFloat(value(0))*100), 100)/100))
)
)
// passengers
MAPVALUE(1, parseFloat(value(1)))
CHART(
chartOption({
xAxis: { data: column(0) },
yAxis: {},
series: [
{type: "line", name: "passengers", smooth: false, data: column(1)}
]
})
)
![](../../img/line_airpassengers.jpg)
Last updated on