I’m sorry I’m having trouble explaining myself recently due to some health issues.
I do have my habits inside my daily notes, under a ## Habit section and with the inline metadata approach Meditation::0.
However, I want to be able to see my weekly progress on habits, hence the question.
I managed to make it work with the 2023-XX format :
TABLE WITHOUT ID
file.link as Date,
choice("Morning water"=1,"✅","❌") as "Morning Water",
choice("Mobility"=1,"✅","❌") as "Mobility",
choice("Meditation"=1,"✅","❌") as "Meditation",
choice("Stretching"=1,"✅","❌") as "Stretching"
FROM "-Daily-Notes"
WHERE dateformat(date(file.name), "yyyy-WW") = "2023-18"
SORT file.link ASC
I just need to add your escaping and I’ll be good to go !