search

TuiQiao / CBoard

An easy to use, self-service open BI reporting and BI dashboard platform.
https://tuiqiao.github.io/CBoardDoc/#/
Apache License 2.0
3.02k stars 1.17k forks source link

预聚合表达式如何实现ifnull(sum(销量)/sum(订单数),0) #691

Closed SongGary closed 4 years ago

SongGary commented 4 years ago

预聚合表达式如何实现ifnull(sum(销量)/sum(订单数),0) 这样写通不过，正确写法是什么？

yzhang921 commented 4 years ago

脚本语法能简单支持下面这种, 非常规用法，不太推荐： 原理是把每个聚合当成一个js 语法的常量做 eval 计算，你可以试试

if (sum(store_cost)==0) {0} else {sum(store_cost)/count(store_sales)}