囧
OzQuery
体验台
检测后端中…
预设示例
分类销售额
sum(amount) 按商品分类聚合，体验 groupBy + 聚合
月度订单趋势
created_at 按 month 粒度截断，体验时间 grain
已支付订单明细
双表 JOIN + status 过滤 + 分页，体验完整查询
渠道客单价
排除退款单，avg(amount) 按渠道聚合
OzQuery JSON（可自由编辑）
⌘/Ctrl + Enter 执行
{ "version": 1, "datasource": "olap", "sources": [ { "table": "orders", "alias": "o" }, { "table": "products", "alias": "p", "join": { "type": "left", "on": "o.product_id = p.id" } } ], "fields": [ { "name": "p.category" }, { "name": "o.amount", "agg": "sum", "alias": "total_amount" }, { "name": "o.id", "agg": "count", "alias": "order_count" } ], "groupBy": [ "p.category" ], "orders": [ { "name": "total_amount", "dir": "desc" } ] }
运行查询 →
查询结果
选择预设或直接编写 OzQuery，点击「运行查询」
数据来自本地 olap 示例库（orders / products / customers）