背景:
通过脚本生成数据:
let vMinDate=num(Date('2015-01-01'));
let vMaxDate=num(Date('2018-06-11'));
日历数据:
LOAD
Date(TempDate) as ddate,
num(WeekDay(TempDate)) as 星期数,
Day(TempDate) as 日,
Week(TempDate) as 周,
Num(Month(TempDate)) as 月,
Month(TempDate) as 月份,
Year(TempDate) as 年,
'Q'&Ceil(Month(TempDate) / 3) as 季度;
LOAD
$(vM