先计算昨天的总费用,使用coalesce函数当未产生费用时返回0,round函数取三位小数,然后通过compare函数计算同比。 使用数值图中的同比环比图,展示昨天的消费总额及与上个月的同比情况
sql
source :bill |
select
round(diff [1], 2),
round(diff [2], 2),
round(diff [3] * 100 -100, 2)
from(
select
compare("昨日消费", 604800) as diff
from(
select
round(coalesce(sum(PretaxAmount), 0), 3) as "昨日消费"
from
log
)
)
SQL查询结果样例: