Description
调用指标接口的时候,不支持自定义分组查询
指标设计
{
"id": "statistics_order_num",
"name": "根据不同维度查询订单数量",
"kn_id": "e_commerce",
"branch": "main",
"tags": [],
"comment": "【业务口径】基于对象类 sales_orders;时间维为 order_date;对 order_number 做 count_distinct,表示按订单号去重后的订单量(避免一行多商品等导致重复计数时,以订单号唯一性为准,具体以数据源为准)。\n\n【取数说明】在 ontology-query 查询指标数据时,若请求体使用 instant=true,在跨自然年等长区间下可能出现聚合结果为 0 的现象;建议采用 instant=false,并将 step 设为 month(按月序列)或 year(按年汇总),通过 time.start、time.end(毫秒时间戳)限定分析区间。自然年区间宜按业务时区(如 Asia/Shanghai)换算起止时刻。\n\n【归属】知识网络 e_commerce;指标标识 statistics_order_num。",
"icon": "",
"color": "",
"unit_type": "numUnit",
"unit": "none",
"metric_type": "atomic",
"scope_type": "object_type",
"scope_ref": "sales_orders",
"time_dimension": {
"property": "order_date"
},
"calculation_formula": {
"aggregation": {
"property": "order_number",
"aggr": "count_distinct"
}
},
"analysis_dimensions": [
{
"name": "order_number",
"display_name": "订单编号"
},
{
"name": "payment_fee",
"display_name": "支付手续费"
},
{
"name": "shipping_method_id",
"display_name": "运输方式ID"
},
{
"name": "platform_coupon_discount",
"display_name": "平台优惠券折扣"
},
{
"name": "total_amount_after_discount",
"display_name": "优惠后总金额"
},
{
"name": "total_discount",
"display_name": "总折扣金额"
},
{
"name": "final_amount",
"display_name": "最终金额"
},
{
"name": "refundable_amount",
"display_name": "可退金额"
},
{
"name": "tax_amount",
"display_name": "税费"
},
{
"name": "status",
"display_name": "订单状态"
},
{
"name": "member_price",
"display_name": "会员价"
},
{
"name": "insurance_fee",
"display_name": "保险费"
},
{
"name": "point_discount",
"display_name": "积分抵扣金额"
},
{
"name": "shipping_address_id",
"display_name": "运输地址ID"
},
{
"name": "refund_amount",
"display_name": "退款金额"
},
{
"name": "customer_id",
"display_name": "客户ID"
},
{
"name": "product_amount",
"display_name": "商品总金额"
},
{
"name": "quotation_id",
"display_name": "报价单ID"
},
{
"name": "updated_at",
"display_name": "updated_at"
},
{
"name": "order_date",
"display_name": "订单日期"
},
{
"name": "coupon_discount",
"display_name": "优惠券折扣金额"
},
{
"name": "paid_amount",
"display_name": "已付金额"
},
{
"name": "shipping_fee",
"display_name": "运费金额"
},
{
"name": "created_at",
"display_name": "created_at"
},
{
"name": "other_fees",
"display_name": "其他费用"
},
{
"name": "installment_fee",
"display_name": "分期手续费"
},
{
"name": "coupon_id",
"display_name": "优惠券ID"
},
{
"name": "remark",
"display_name": "备注"
},
{
"name": "merchant_coupon_discount",
"display_name": "商家优惠券折扣"
},
{
"name": "created_by",
"display_name": "创建人"
},
{
"name": "id",
"display_name": "id"
},
{
"name": "delete_at",
"display_name": "删除时间"
},
{
"name": "packing_fee",
"display_name": "包装费"
},
{
"name": "salesperson_id",
"display_name": "销售员ID"
},
{
"name": "promotion_price",
"display_name": "促销价"
},
{
"name": "taxable_amount",
"display_name": "应税金额"
},
{
"name": "full_discount_amount",
"display_name": "满减金额"
},
{
"name": "total_amount",
"display_name": "总金额"
},
{
"name": "updated_by",
"display_name": "更新人"
},
{
"name": "platform_service_fee",
"display_name": "平台服务费"
},
{
"name": "refunded_amount",
"display_name": "已退金额"
},
{
"name": "actual_payment",
"display_name": "实付金额"
},
{
"name": "original_price",
"display_name": "商品原价"
},
{
"name": "refund_processing_fee",
"display_name": "退款手续费"
},
{
"name": "company_id",
"display_name": "公司ID"
},
{
"name": "subtotal_amount",
"display_name": "小计金额"
}
],
"creator": {
"id": "",
"type": "",
"name": ""
},
"updater": {
"id": "ff8ef3da-3e12-11f1-8993-261248b384b3",
"type": "user",
"name": ""
},
"update_time": 1778763813702,
"module_type": "metric",
"_score": 2.735184
}
请求参数
{
"analysis_dimensions": ["status"],
"limit": 50
}
没有按预期进行分组,实际执行的sql如下
SELECT COUNT(DISTINCT order_number) AS __value FROM sales_platform.sales_orders LIMIT 50 OFFSET 0,
预期sql
SELECT status ,COUNT(DISTINCT order_number) AS __value FROM sales_platform.sales_orders group by status LIMIT 50 OFFSET 0,
预期结果:
1、按 分析维度进行 分组,如果instance为false,且time参数选择了step,则安分析维度 + step进行分组
Environment
Additional context
Description
调用指标接口的时候,不支持自定义分组查询
指标设计
{
"id": "statistics_order_num",
"name": "根据不同维度查询订单数量",
"kn_id": "e_commerce",
"branch": "main",
"tags": [],
"comment": "【业务口径】基于对象类 sales_orders;时间维为 order_date;对 order_number 做 count_distinct,表示按订单号去重后的订单量(避免一行多商品等导致重复计数时,以订单号唯一性为准,具体以数据源为准)。\n\n【取数说明】在 ontology-query 查询指标数据时,若请求体使用 instant=true,在跨自然年等长区间下可能出现聚合结果为 0 的现象;建议采用 instant=false,并将 step 设为 month(按月序列)或 year(按年汇总),通过 time.start、time.end(毫秒时间戳)限定分析区间。自然年区间宜按业务时区(如 Asia/Shanghai)换算起止时刻。\n\n【归属】知识网络 e_commerce;指标标识 statistics_order_num。",
"icon": "",
"color": "",
"unit_type": "numUnit",
"unit": "none",
"metric_type": "atomic",
"scope_type": "object_type",
"scope_ref": "sales_orders",
"time_dimension": {
"property": "order_date"
},
"calculation_formula": {
"aggregation": {
"property": "order_number",
"aggr": "count_distinct"
}
},
"analysis_dimensions": [
{
"name": "order_number",
"display_name": "订单编号"
},
{
"name": "payment_fee",
"display_name": "支付手续费"
},
{
"name": "shipping_method_id",
"display_name": "运输方式ID"
},
{
"name": "platform_coupon_discount",
"display_name": "平台优惠券折扣"
},
{
"name": "total_amount_after_discount",
"display_name": "优惠后总金额"
},
{
"name": "total_discount",
"display_name": "总折扣金额"
},
{
"name": "final_amount",
"display_name": "最终金额"
},
{
"name": "refundable_amount",
"display_name": "可退金额"
},
{
"name": "tax_amount",
"display_name": "税费"
},
{
"name": "status",
"display_name": "订单状态"
},
{
"name": "member_price",
"display_name": "会员价"
},
{
"name": "insurance_fee",
"display_name": "保险费"
},
{
"name": "point_discount",
"display_name": "积分抵扣金额"
},
{
"name": "shipping_address_id",
"display_name": "运输地址ID"
},
{
"name": "refund_amount",
"display_name": "退款金额"
},
{
"name": "customer_id",
"display_name": "客户ID"
},
{
"name": "product_amount",
"display_name": "商品总金额"
},
{
"name": "quotation_id",
"display_name": "报价单ID"
},
{
"name": "updated_at",
"display_name": "updated_at"
},
{
"name": "order_date",
"display_name": "订单日期"
},
{
"name": "coupon_discount",
"display_name": "优惠券折扣金额"
},
{
"name": "paid_amount",
"display_name": "已付金额"
},
{
"name": "shipping_fee",
"display_name": "运费金额"
},
{
"name": "created_at",
"display_name": "created_at"
},
{
"name": "other_fees",
"display_name": "其他费用"
},
{
"name": "installment_fee",
"display_name": "分期手续费"
},
{
"name": "coupon_id",
"display_name": "优惠券ID"
},
{
"name": "remark",
"display_name": "备注"
},
{
"name": "merchant_coupon_discount",
"display_name": "商家优惠券折扣"
},
{
"name": "created_by",
"display_name": "创建人"
},
{
"name": "id",
"display_name": "id"
},
{
"name": "delete_at",
"display_name": "删除时间"
},
{
"name": "packing_fee",
"display_name": "包装费"
},
{
"name": "salesperson_id",
"display_name": "销售员ID"
},
{
"name": "promotion_price",
"display_name": "促销价"
},
{
"name": "taxable_amount",
"display_name": "应税金额"
},
{
"name": "full_discount_amount",
"display_name": "满减金额"
},
{
"name": "total_amount",
"display_name": "总金额"
},
{
"name": "updated_by",
"display_name": "更新人"
},
{
"name": "platform_service_fee",
"display_name": "平台服务费"
},
{
"name": "refunded_amount",
"display_name": "已退金额"
},
{
"name": "actual_payment",
"display_name": "实付金额"
},
{
"name": "original_price",
"display_name": "商品原价"
},
{
"name": "refund_processing_fee",
"display_name": "退款手续费"
},
{
"name": "company_id",
"display_name": "公司ID"
},
{
"name": "subtotal_amount",
"display_name": "小计金额"
}
],
"creator": {
"id": "",
"type": "",
"name": ""
},
"updater": {
"id": "ff8ef3da-3e12-11f1-8993-261248b384b3",
"type": "user",
"name": ""
},
"update_time": 1778763813702,
"module_type": "metric",
"_score": 2.735184
}
请求参数
{
"analysis_dimensions": ["status"],
"limit": 50
}
没有按预期进行分组,实际执行的sql如下
SELECT COUNT(DISTINCT order_number) AS __value FROM sales_platform.sales_orders LIMIT 50 OFFSET 0,
预期sql
SELECT status ,COUNT(DISTINCT order_number) AS __value FROM sales_platform.sales_orders group by status LIMIT 50 OFFSET 0,
预期结果:
1、按 分析维度进行 分组,如果instance为false,且time参数选择了step,则安分析维度 + step进行分组
Environment
OS: Linux node1 6.6.0-132.0.0.111.oe2403sp3.x86_64 init project #1 SMP Mon Dec 29 23:07:38 CST 2025 x86_64 x86_64 x86_64 GNU/Linux
Browser: [chrome]
Version: [版本 148.0.7778.96(正式版本) (64 位)]
Additional context