TABLE obj1-status AS "OBJ1",obj2-status AS "OBJ2", obj3-status AS "OBJ3",obj4-status AS "OBJ4",obj5-status AS "OBJ5",week AS "周次",date AS "日期"FROM "复盘/周复盘"WHERE type = "weekly-review"SORT file.ctime DESCLIMIT 4
TABLE length(rows) AS "日记总数", length(rows) - 1 AS "连续天数"FROM "复盘/日记/2026"WHERE type = "daily"GROUP BY year
最近日记
TABLE date, week, mood, energyFROM "复盘/日记/2026"WHERE type = "daily"SORT date DESCLIMIT 7
日记完整性
TABLE length(rows) AS "日记数",average(rows.energy) AS "平均能量",average(rows.mood) AS "平均心情"FROM "复盘/日记/2026"WHERE type = "daily"WHERE date >= date(dateformat(date(today) - dur(30 days), "yyyy-MM-dd"))GROUP BY month
🧠 判断力统计
Taste Signal 积累
TABLE length(rows) AS "总 Signal 数"FROM "复盘/日记/2026"WHERE type = "daily"FLATTEN file.lists as listWHERE contains(list.text, "Taste Signal")
本周 Taste Signals
TABLE date, list.text AS "Taste Signal"FROM "复盘/日记/2026"WHERE type = "daily"WHERE date >= date(dateformat(date(today) - dur(7 days), "yyyy-MM-dd"))FLATTEN file.lists as listWHERE contains(list.text, "Taste Signal")SORT date DESC
Taste Signal 分类统计
类型
本月
累计
决策 Decision
__
__
沟通 Communication
__
__
创作 Creation
__
__
拒绝 Rejection
__
__
产品 Product
__
__
技术 Technical
__
__
其他
__
__
📈 周复盘统计
本月周复盘
TABLE date, week, obj1-status, obj2-status, obj3-status, obj4-status, obj5-statusFROM "复盘/周复盘"WHERE type = "weekly-review"WHERE date >= date(dateformat(date(today) - dur(30 days), "yyyy-MM-dd"))SORT date DESC
周复盘完成率
周次
完成
日期
W25
✅
2026-06-20
W26
⏳
进行中
W27
○
未开始
W28
○
未开始
⚡ 效率指标
任务完成率
TABLE length(rows) AS "总任务",length(filter(rows, (r) => !r.completed)) AS "已完成",round(length(filter(rows, (r) => !r.completed)) / length(rows) * 100) AS "完成率 %"FROM "复盘/日记/2026"WHERE type = "daily"WHERE date >= date(dateformat(date(today) - dur(7 days), "yyyy-MM-dd"))FLATTEN file.tasks as task
日均任务
TABLE round(length(file.tasks) / length(rows), 1) AS "日均任务",length(filter(rows, (r) => !r.completed)) AS "已完成"FROM "复盘/日记/2026"WHERE type = "daily"WHERE date >= date(dateformat(date(today) - dur(7 days), "yyyy-MM-dd"))GROUP BY week
📊 心情与能量趋势
心情分布(本月)
TABLE length(rows) AS "天数",mood AS "心情"FROM "复盘/日记/2026"WHERE type = "daily"WHERE date >= date(dateformat(date(today) - dur(30 days), "yyyy-MM-dd"))GROUP BY mood
能量趋势
TABLE date,energy,moodFROM "复盘/日记/2026"WHERE type = "daily"WHERE date >= date(dateformat(date(today) - dur(14 days), "yyyy-MM-dd"))SORT date ASC
🎯 目标追踪
OBJ 月度趋势
TABLE month AS "月份",average(obj1-status) AS "OBJ1",average(obj2-status) AS "OBJ2",average(obj3-status) AS "OBJ3",average(obj4-status) AS "OBJ4",average(obj5-status) AS "OBJ5"FROM "复盘/周复盘"WHERE type = "weekly-review"GROUP BY month
里程碑达成
里程碑
目标日期
实际日期
状态
Payroll 项目启动
TBD
-
⏳
E-Sign 上线
TBD
-
⏳
Agent v1.0
TBD
-
⏳
Jason Exam
TBD
-
⏳
🧹 Inbox 统计
待整理项目
TABLE length(rows) AS "待整理数"FROM "Inbox"
Inbox 清理频率
周期
清理数
转化率
本周
__
__%
本月
__
__%
📅 复盘完成度
本月复盘
类型
状态
最近完成
日记
✅/⏳
__/30 天
周复盘
✅/⏳
__/4-5 次
月复盘
○
未开始
复盘质量自评
类型
上次完成日期
质量评分
周复盘
W25
⭐⭐
月复盘
-
-
💡 判断力自评
本周判断质量
每周自问:
能清晰说出本周最重要的 3 个判断吗?
这 3 个判断的结果如何?
有没有后悔的判断?为什么?
本周拒绝了什么?为什么?
判断力雷达图
维度
评分 (1-5)
说明
问题识别
⭐⭐⭐
能发现关键问题
优先级判断
⭐⭐⭐
知道什么先做
风险评估
⭐⭐
有时过于乐观
决策速度
⭐⭐⭐
信息充分时果断
结果复盘
⭐⭐⭐
能从结果中学习
📝 数据趋势图
OBJ 进度趋势
TABLE week AS "周",obj1-status AS "OBJ1",obj2-status AS "OBJ2",obj3-status AS "OBJ3",obj4-status AS "OBJ4",obj5-status AS "OBJ5"FROM "复盘/周复盘"WHERE type = "weekly-review"SORT week ASC