Help with Weekly Habits Tracking

Help
1

What I’m trying to do

I saw this topic where the OP does a neat display of daily trends. I would like to do something very similar, but with my weekly habit tracking.

I have a weekly note that has a list of habit tasks within a heading called “Habits”. I would like to create a query that shows the count of completed tasks from this week’s note compared to the count of completed tasks last week. Also, this query would be in my dashboard and not my weekly note.

Things I have tried

I was able to create a query that mostly gets there, but as two rows with half the data on each row as such:

|Habits|
|5 → 0 ▼|
|0 → 6 ▲|

However, this has the previous week’s value (5) on one row with the current week’s value (6) on the second row. I need the output to be a single row with the 5 and 6.

The above is using this query:

TABLE WITHOUT ID
	completedLastWeek + " -> " + completedThisWeek + " " + choice( completedLastWeek > completedThisWeek, "▼", choice( completedLastWeek < completedThisWeek, "▲", "◌" )) AS "Habits"
FROM "@Journal/Weekly/2025"
WHERE dateformat(file.cday, "W") = dateformat(date(today), "W") OR dateformat(file.cday, "W") = dateformat(date(today) - dur(7 days), "W")
FLATTEN length(filter(file.tasks, (i) => meta(i.section).subpath = "Habits" AND i.status = "x" AND dateformat(date(i.completion), "W") = dateformat(date(today), "W"))) as completedThisWeek
FLATTEN length(filter(file.tasks, (i) => meta(i.section).subpath = "Habits" AND i.status = "x" AND dateformat(date(i.completion), "W") = dateformat(date(today) - dur(7 days), "W"))) as completedLastWeek

This was mostly from trial and error, but I’m hoping maybe a clever use of FLATTEN or something can get me a single row back with the correct values.

I think I could probably achieve what I need within the current weekly note (each week would have a dataview that includes current and previous week similar to the original post noted above). I could then do an embedded link to that query from my dashboard, but I’m hoping I can create a standalone query so I don’t have to create another query in each weekly note.

Any thoughts?
Thanks!

2

A rephrasing of your question is that you want information from two different week notes to be displayed in the same row, and it seems like this is the only row you’ll display in that table. This would require that you group those two files together so that the rows join up.

One way of doing this would something like the following:

```dataview
TABLE WITHOUT ID
  choice( lastWeekCount > thisWeekCount, "▼", 
  choice( thisWeekCount > lastWeekCount, "▲", "◌" )) as Habits

FROM "@Journal/Weekly/2025"
FLATTEN dateformat(file.cday, "W") as weekNumber
FLATTEN dateformat(date(today), "W") as thisWeekNumber
FLATTEN dateformat(date(today) - dur(7 days), "W") as lastWeekNumber

WHERE weekNumber = thisWeekNumber OR weekNumber = lastWeekNumber

FLATTEN length(filter(file.tasks, (i) => meta(i.section).subpath = "Habits" AND i.status = "x" AND weekNumber = thisWeekNumber) as completedThisWeek
FLATTEN length(filter(file.tasks, (i) => meta(i.section).subpath = "Habits" AND i.status = "x" AND weekNumber = lastWeekNumber) as completedLastWeek
GROUP true

// Simplify the grouped expression a little
FLATTEN firstvalue(rows.completedLastWeek) as lastWeekCount
FLATTEN firstvalue(rows.completedLastWeek) as thisWeekCount
```

I’m not sure how easy it would be (or even if it’s possible) to change this query to accomodate multiple week showing the same kind of information.

That would require something I also would consider doing for a given weeks entry and that is to utilise file lookup directly. I don’t know if what your file name is like, or if you’ve got a week property denoting the number of this week (and potentially the year).

But if you’ve got the information available, it should be possible to use this.file.tasks to get to the current files tasks, and then something a kin to link( this.week-1 ).file.tasks (where this.week-1 would give you the name of last weeks file name), to access last weeks task.

3

I haven’t had a chance to try your suggestion yet, but wanted to add, if it helps, that my weekly notes have a title in the form of “Week WW - yyyy” (e.g., Week 14 - 2025).

Also, I would be open to having the dataview query in the weekly notes (since there are far fewer of those than dailies) and then use embedded links to put the results in my daily notes. I was looking into that yesterday, but couldn’t really figure it out using ‘this’ in the weekly note.

I’ll look at your suggestion later to see if I can get that to work…

Thanks!

4

My skills are not that advanced yet to comment on the code, but I would point out that you may want to make your note file name and title in this format: 2025 - Week 14. It makes for far easier sorting in the file manager later…otherwise you will have all the weeks clumped together across various years. In fact I do only daily notes and so the file system (whether OS or obsidian) is still nice and responsive, I have it broken down like so: calendar/2025/04-April/2025-04-01-Tuesday

Why include the full date in the daily note when I have such categorization? Simple…because I do various js code…and if I mess up, or some plugin messes up that deals with moving files around, I can always spot if a file is out of place since it has a full date. Over decades this has proven a good rule to follow.

Think of it like filtering. Whenever you will query things in future, or even browsing the file manager, you filter by the biggest to the smallest and it works really well. It’s how we humans search for things anyways, so it’s not going against the grain.

Cheers