TABLE length(rows) AS "打卡天数",round(length(rows) / 7 * 100) AS "完成率 %"FROM "Years/2026/Daily"WHERE type = "daily"WHERE date >= date(dateformat(date(today) - dur(7 days), "yyyy-MM-dd"))
习惯连续记录
TABLE date, contains(file.lists, "早起") AS "早起",contains(file.lists, "运动") AS "运动",contains(file.lists, "阅读") AS "阅读",contains(file.lists, "复盘") AS "复盘"FROM "Years/2026/Daily"WHERE type = "daily"WHERE date >= date(dateformat(date(today) - dur(14 days), "yyyy-MM-dd"))SORT date DESC