option = {
dataset: {
source: [
['product', 'sales'],
['A', 100],
['B', 120],
['C', 80],
['D', 150]
],
transform: {
type: 'filter',
config: {
condition: row => row[1] > 100 // 筛选 sales 大于 100 的行
}
}
},
// 其他图表配置
};
例如table有两列，分别是product，sales
[此贴子已经被作者于2024/11/3 13:29:58编辑过]
http://www.foxtable.com/mobilehelp/topics/0167.htm
大概这样
Dim ja As New JArray
Dim ja2 As new JArray
ja2.add("product")
ja2.add("sales")
ja.add(ja2)
dim t as table = table("某表")
for each r as row in t.rows
ja2= new JArray
ja2.add(cstr(r("product")))
ja2.add(cstr(r("sales")))
ja.add(ja2)
next
msgbox(ja.tostring)