Versions Compared

Old Version 31

changes.mady.by.user 李龙飞

Saved on

compared with

New Version 32

changes.mady.by.user 管理员

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

运算函数表达式描述
计算占比{度量A}/total({度量A})对应数据行度量A占合计的百分比
计算完成率{度量A}/{度量B}对应数据行度量A占度量B的比例
计算同比或环比({度量A}-{去年度量A})/{去年度量A}对应数据行度量A较上期值的增长比率
去重计数

countDistinct({维度A去重},度量B计数=1)

countDistinct({店铺档案编号},销售网点=1)
计算上月汇总的数量的SQL：
Tip
title 示例：计算上月汇总数量

select 月份,sum(数量) as 数量 ,
( select sum(数量) from workbook1 t2 where t2.月份||'-01'=date(t1.月份||'-01','-1 month') ) as 上月数量
from workbook1 t1 group by 月份

Tip
title 示例：计算过去第1周收入

(select sum(纯收入) from 测试数据 A where A.省份=测试数据.省份 and A.周=printf('%d周', case when cast(strftime('%j', 测试数据.日期) as int) > 300 and cast(strftime('%W', date(测试数据.日期,'+2 day', 'localtime')) as int) < 2 then '53' else strftime('%W', date(测试数据.日期,'+2 day', 'localtime')) end -1 ) )