# Daily and Weekly Reviews + dataview

**URL:** <https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021>\
**Category:** Workflows & Templates\
**Tags:** dataview\
**Created:** [April 23, 2021, 1:57am UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021 "2021-04-23T01:57:29Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![arminta](https://forum.obsidian.md/user_avatar/forum.obsidian.md/arminta/32/9078_2.png) [@arminta](https://forum.obsidian.md/u/arminta)\
**Post date:** [April 23, 2021, 1:57am UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/1 "2021-04-23T01:57:29Z")

</div>

I’m a big believer in doing periodic reviews. I do reviews each morning, night, week, month, quarter and year.

Using dataview I can easily keep track of metadata that I want to review inline in the page and have it roll up into the bigger timeframes. For example I can track the things I want to improve and use dataview to display the previous day’s value to reflect on. I can also track how well I’m completing my habits each day and see the results and average of those values for the week and month.

Here are examples of my daily and weekly templates. The screenshots are zoomed way out to show more of the page. You can probably open them in a new page to get a closer look.

 ![Screen Shot 2021-04-22 at 18.46.57](https://forum.obsidian.md/uploads/default/original/2X/1/1149d663add5330a26e6c12b9027d865229d8681.png)

## Inbox

```auto
button
name Add New
type note(New Item) template
action Inbox Template
class dataview-button

```

* * *

```auto
dataview
table striptime(file.ctime) as Created, striptime(file.mtime) as Modified 
from #Inbox 
sort file.ctime asc

```

## Daily Tracking

### Basic Info

Week:: [[{{date:YYYY}}-W{{date:ww}}]]  
Eternal Week:: [[Week {{date:ww}}]]  
Month:: [[{{date:YYYY-MM}}]]  
Eternal Month:: [[{{date:MMMM}}]]  
Eternal Quarter:: [[Quarter {{date:Q}}]]  
Quarter:: [[{{date:YYYY}}-Q{{date:Q}}]]  
Weekday:: [[{{date:dddd}}]]  
Day:: [[{{date:MM-DD}}]]  
Yesterday:: [[{{yesterday}}]]  
Tomorrow:: [[{{tomorrow}}]]

### Morning Journal

☀ **Good Morning!!** ☀

How was your sleep last night?

- Sleep Comments::

How are you feeling this morning?

- Morning Comments::
- Energy Level::

📖 **Morning Pages** 📖

I’m grateful for

- Grateful for::

What would make today great?

- Make today great::

Affirmations. I am…

- Affirmations::

How can I be better today?

- Yesterday I completed `=[[{{yesterday}}]].habits-completed` of my habits.
- I wanted to improve: `=[[{{yesterday}}]].need-to-improve`.

Be better::

### 🧘‍♀️ Mindset 🧘‍♀️

#### Visualization

**Take a minute to visualize the day ahead…**

#### Meditation

**Do 5 minutes of meditation in Headspace.**

- Mark off Today’s Meditation Task
- Meditation::

### ☘ Health Stats ☘

Ketones::  
Blood Oxygen::  
Blood Pressure Dia::  
Blood Pressure Sys::  
Body Temp::  
Weight::

### Fitness

- [[Coda Fitness Page]]

#### Today’s Workout

```auto
button
name Add Workout
type note(New Workout) template
action Workout Template
class dataview-button

```

##### Workouts

```auto
dataview
table Type, Sets, Reps, max-hr, Calories
from #workouts 
where date = this.file.link

```

##### Exercises

```auto
dataview
table pr, weight, goal-weight, master-exercise
from #exercises  
where date = this.file.link

```

### Habits

- Meditation::
- Sunlight::
- Journal::
- Book::
- Exercise::
- Eye Exercises::
- Walk::
- Music::
- Inbox Review::
- Japanese::
- Mobility::
- Pocket::
- Email Review::
- Sunlight::
- Nightly Review::

### 🌙 End of Day Wind-Down 🌙

Daily Journal::  
Today’s Wins::  
[[Accomplishments]]::  
Need to Improve::  
[[Disappointments]]::  
Day Rating::  
Diet Rating::  
Stress::  
Illness::  
Habits Completed::

#dailyjournal

* * *

## Tasks

```auto
button
name Add Task
type note(New Task) template
action Task Template
class dataview-button

```

### Available Tasks

```auto
dataview
table Completed, Priority, Project, defer-date as "Defer Date", due-date as "Due Date", recur-length as "Recur Length", defer-date + recur-length as "Next Date"
from #tasks
where defer-date < date(now) and completed != 1
sort doDate asc

```

## Readwise

```auto
dataview
table Author, elink(URL) as URL, file.mtime, file.size, file.tags
from [[{{date:YYYY-MM-DD}}]] and #Readwise 
sort file.name asc

```

## Daily Notes

 ![Screen Shot 2021-04-22 at 18.50.00](https://forum.obsidian.md/uploads/default/original/2X/2/2dd77a2d8f926eaba4615b02e685e91e5a4842f2.png)

#weeks  
Days:: [[{{sunday:gggg-MM-DD}}]], [[{{monday:gggg-MM-DD}}]], [[{{tuesday:gggg-MM-DD}}]], [[{{wednesday:gggg-MM-DD}}]], [[{{thursday:gggg-MM-DD}}]], [[{{friday:gggg-MM-DD}}]], [[{{saturday:gggg-MM-DD}}]]

Focus::  
Objective::  
Month::

## Tasks Completed this Week

```auto
dataview
table file.mtime as Modified, Priority, defer-date as "Defer Date"
from #tasks 
where contains(this.days, completed-date)

```

## Review

- Review [[Purpose and Mission]]
- Review [[Accomplishments]]
- Review [[Disappointments]]
- Review Previous 2 weeks → Does anything need follow-up?
- Review Upcoming 3 weeks → Need to prepare for anything?
- Review [[Projects]] → Have 1 active Task for each Project.

### Projects

```auto
dataview
table Status, length(tasks) as Total, sum(tasks.completed) as Completed, sum(tasks.completed) / (length(tasks)) * 100 + "%" as Progress, tasks[0] as "Next", file.mtime as Modified
from #projects
where Status = "Active"
sort file.mtime asc

```

### Highs, Lows and Lessons

This week I was grateful for: `=this.days.grateful-for`  
Gratitude::

This week my wins were: `=this.days.todays-wins`  
My accomplishments were: `=this.days.accomplishments`  
Highs::

After this week I need to improve: `=this.days.need-to-improve`  
My disappointments were: `=this.days.disappointments`  
Lows::

Lessons::

### Weekly Stats

```auto
dataview
table Days.Ketones as Ketones, sum(Days.Ketones)/7 as "Avg Ketones", Days.energy-level as "Energy Level", sum(Days.energy-level)/7 as "Avg Energy", Days.day-rating as "Day Rating", sum(Days.day-rating)/7 as "Avg Day Rating", Days.diet-rating as "Diet Rating", sum(Days.diet-rating)/7 as "Avg Diet Rating"
from #weeks 
where file.name = this.name

```

## Finances

- Update Debts
- Update Assets
- Update Investments
- Review Bills

## Trading

- Update [[Trading Tracker]]
- Add new [[Weekly Trade Review]]
- Review previous [[Weekly Trade Review]]

## Admin

- Clear out Email Inbox
- Clean iMac Desktop and Download Folder
- Clean MacBook Desktop and Download Folder
- Run CleanMyMac on iMac and MacBook
- Add Focus and Objective for next week

* * *

I have similar templates for the larger timeframes and everything ties into eachother.

I also have dataviews set up so I can see all of my days, weeks, months, etc. Example for days:

#databases  
Area:: Reviews

```auto
dataview
table Day as "_Day_", Weekday, row["Sleep Comments"] as "Sleep Comments", Week as "_Week_", Month, row["Morning Comments"] as "Morning_Comments", row["Make today great"] as "Make_Today_Great",row["Grateful for"] as "_Grateful_For_", row["Energy Level"] as "Energy Level", Ketones, day-rating as "Day Rating", diet-rating as "Diet Rating"
from #dailyjournal
where !contains(file.name, "Template")
sort file.day desc

```

Related:

> [@Knowledge Management dataview examples](https://forum.obsidian.md/t/knowledge-management-dataview-examples/17012):
>
> name Add Topic type note(New Topic) template action Knowledge Topic Template class dataview-button table importance, file.mtime as Last\_Modified\_\_, pillars as Pillars\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_, habitsRoutines as Habits\_and\_Routines\_\_\_, courses-and-training from #knowledgeTopic sort file.mtime desc #knowledgeTopic Status:: Active Importance:: Goals:: Pillars:: Habits and Routines:: Courses and Training:: Relevant Reso…

> [@Dataview task and project examples](https://forum.obsidian.md/t/dataview-task-and-project-examples/17011):
>
> Ok, here are some examples of templates and dataviews for task management: name Add Task type note(New Task) template action Task Template class dataview-button Available Tasks table Completed, Priority, Project, defer-date as "Defer Date", due-date as "Due Date", recur-length as "Recur Length", defer-date + recur-length as "Next Date" from #tasks where defer-date \< date(now) and completed != 1 sort doDate asc Upcoming Tasks table Completed, Priority, P…

> [@Exercise and workout dataview ideas](https://forum.obsidian.md/t/exercise-and-workout-dataview-ideas/17014):
>
> I’m still redoing a bunch of metadata for my fitness stuff so some of these aren’t completely filled out with examples, but I wanted to post some ideas for using obsidian and dataview to track workouts. name Add Workout type note(New Workout) template action Workout Template class dataview-button table Date, Type, set-type, planned-rpe, Sets, Reps, max-hr, Calories from #workouts sort date desc #databases Area:: Fitness

> [@Dataview for reviewing and processing media](https://forum.obsidian.md/t/dataview-for-reviewing-and-processing-media/17136):
>
> I use dataview to help me process and organize all of the media that I go through (books, articles, videos, movies, papers, etc). I also use the Readwise tool and plugin to funnel most of what I consume into my vault. Anything I come across that might be interesting gets saved into Pocket and I either highlight in Pocket which sends to Readwise, or highlight with Hypothesis which goes into Readwise. Here is a shot of my media review page: Here’s the markd…

---

<div class="post-metadata">

**Author:** ![rafaelfrageri](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/r/6de8d8/32.png) [@rafaelfrageri](https://forum.obsidian.md/u/rafaelfrageri)\
**Post date:** [April 23, 2021, 2:13am UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/2 "2021-04-23T02:13:58Z")

</div>

What a great job 👏 👏

How did you make these buttons?

Thank you

---

<div class="post-metadata">

**Author:** ![arminta](https://forum.obsidian.md/user_avatar/forum.obsidian.md/arminta/32/9078_2.png) [@arminta](https://forum.obsidian.md/u/arminta)\
**Post date:** [April 23, 2021, 2:17am UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/3 "2021-04-23T02:17:01Z")

</div>

I used the buttons plugin! The code for the buttons is above in the post.

And here is my css I use to style them:

```auto
.dataview-button {

  border-style: solid;
  border-width: thin;
  border-color: rgb(149, 213, 234);
  color: rgb(149, 213, 234);
  font-weight: bold;
  background-color: transparent;
  padding: 5px 15px;
  font-size: 11px;
}

```

---

<div class="post-metadata">

**Author:** ![rafaelfrageri](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/r/6de8d8/32.png) [@rafaelfrageri](https://forum.obsidian.md/u/rafaelfrageri)\
**Post date:** [April 23, 2021, 2:19am UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/4 "2021-04-23T02:19:30Z")

</div>

Awesome, thank you again

Really nice job

---

<div class="post-metadata">

**Author:** ![ekafyi](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/e/ea666f/32.png) [@ekafyi](https://forum.obsidian.md/u/ekafyi)\
**Post date:** [May 25, 2021, 5:59pm UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/5 "2021-05-25T17:59:16Z")

</div>

Your examples are awesome and my main inspiration to finally jump aboard the dataview plugin train. Just want to say thanks, appreciate your sharing your notes here!

---

<div class="post-metadata">

**Author:** ![somnicide](https://forum.obsidian.md/user_avatar/forum.obsidian.md/somnicide/32/13026_2.png) [@somnicide](https://forum.obsidian.md/u/somnicide)\
**Post date:** [May 27, 2021, 6:45pm UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/6 "2021-05-27T18:45:20Z")

</div>

I really like this! I have just been using a daily template that has some of this information, but I love how intentional you are on the reviews. I haven’t used Dataview yet so would love to hear more about how if your daily template is just a regular .md file that then a different one to pull the data up or if you have a form that you enter in the table.

---

<div class="post-metadata">

**Author:** ![TheAOR](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/t/a87d85/32.png) [@TheAOR](https://forum.obsidian.md/u/TheAOR)\
**Post date:** [June 4, 2021, 9:06pm UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/7 "2021-06-04T21:06:58Z")

</div>

Excuse my language, but holy shit. THANK YOU! I’m so inspired now & you just connected so many dots for me. 😁

---

<div class="post-metadata">

**Author:** ![Ocarinalover](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/o/45deac/32.png) [@Ocarinalover](https://forum.obsidian.md/u/Ocarinalover)\
**Post date:** [June 9, 2021, 9:33am UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/8 "2021-06-09T09:33:50Z")

</div>

Thank you very much for sharing, but it’s too complicated for beginners. could you specify the plugins and setting first and re-arrange the showcasing in

1. Individual files  
file1:  
title:  
content:  
file2:  
title:  
content:
2. Dataview syntax to organize these files

I believe this way is better for others to understand your workflow and fully appreciate your idea. Otherwise, they may be overwhelmed by some of the bugs caused by unfamiliarity with the Dataview plugin and some other plugins that you didn’t mention at the beginning.

---

<div class="post-metadata">

**Author:** ![ekafyi](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/e/ea666f/32.png) [@ekafyi](https://forum.obsidian.md/u/ekafyi)\
**Post date:** [June 15, 2021, 2:50am UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/9 "2021-06-15T02:50:19Z")

</div>

> [@arminta](#):
>
> Today’s Wins::  
> [[Accomplishments]]::

Not about the Obsidian setup itself, but i wonder what is the difference between Wins and Accomplishments? Thanks!

---

<div class="post-metadata">

**Author:** ![TheAOR](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/t/a87d85/32.png) [@TheAOR](https://forum.obsidian.md/u/TheAOR)\
**Post date:** [June 18, 2021, 8:22pm UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/10 "2021-06-18T20:22:29Z")

</div>

I feel like I’ve got a good system going that makes sense for myself. I’m not sure why, but I can’t seem to get the averages working. I pretty much copied what you had word for word, but for some reason it doesn’t seem to recognize stats to average. Any clues on what to look for? Does this require a different plugin for this specific function? Thank you so much!

---

<div class="post-metadata">

**Author:** ![gabecolors](https://forum.obsidian.md/user_avatar/forum.obsidian.md/gabecolors/32/14904_2.png) [@gabecolors](https://forum.obsidian.md/u/gabecolors)\
**Post date:** [July 15, 2021, 7:00pm UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/11 "2021-07-15T19:00:37Z")

</div>

I fear this is too advanced for beginners like me! Just replying here to your note to express my vote as well for more detailed info. I can tell the screenshots are previews of pages with multiple dataviews created. (The button is css so skipping that for now.) The content provided is mostly for templates for the dataviews. But yes the missing piece for me is what the original pages that are being queried look like and how much “tagging” or identification/organization is required to make the dataviews successful.

I’m still hunting on the forum for a zip file of a vault I can dig into with sample pages and dataviews. Once I figure out that, then I’ll try to setup some templates! Anyway to the creator @arminta this is beautiful shui!

---

<div class="post-metadata">

**Author:** ![pgogo](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/p/4bbf92/32.png) [@pgogo](https://forum.obsidian.md/u/pgogo)\
**Post date:** [July 16, 2021, 12:08pm UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/12 "2021-07-16T12:08:03Z")

</div>

Hey,

I want to use dataview, but for some reason it doesn`t work.  
I am trying to use it for books.

What I did:

1. install dataview plugin

2. created a test page for a book:  
 ![image](https://forum.obsidian.md/uploads/default/original/3X/9/0/907792c4b46ad9ef23f1fba7701ebd5e6b780713.png)

3. create a test page for dataview:  
 ![image](https://forum.obsidian.md/uploads/default/original/3X/f/d/fd105d60265ed762c526bb2a678ec31f1c222fb9.png)

And I get this result:  
 ![image](https://forum.obsidian.md/uploads/default/original/3X/e/c/eca08589862faa7672a887cf4c2f6e48af709006.png)

Any idea what I am missing?

Thanks

---

<div class="post-metadata">

**Author:** ![pgogo](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/p/4bbf92/32.png) [@pgogo](https://forum.obsidian.md/u/pgogo)\
**Post date:** [July 19, 2021, 7:14pm UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/13 "2021-07-19T19:14:57Z")

</div>

I found my issue…I forgot to enable to module 😃 Thanks

---

<div class="post-metadata">

**Author:** ![SG7jit](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/s/e0b2c6/32.png) [@SG7jit](https://forum.obsidian.md/u/SG7jit)\
**Post date:** [August 18, 2021, 6:46am UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/14 "2021-08-18T06:46:23Z")

</div>

The way you have used dataview is amazing. Is there some talk that you have given where I can see how you’ve made this?

---

<div class="post-metadata">

**Author:** ![dongmeng789](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/d/43a26b/32.png) [@dongmeng789](https://forum.obsidian.md/u/dongmeng789)\
**Post date:** [September 29, 2021, 12:15am UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/15 "2021-09-29T00:15:35Z")

</div>

Great job!  
By the way, how could I extract the current page’s name by Dataviewjs?  
Thanks a lot!

---

<div class="post-metadata">

**Author:** ![dryice](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/d/9f8e36/32.png) [@dryice](https://forum.obsidian.md/u/dryice)\
**Post date:** [December 17, 2021, 9:12am UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/16 "2021-12-17T09:12:25Z")

</div>

Hi all,

I have adapted many of @arminta’s ideas around Dataview and daily / weekly / monthly reviews.

I have uploaded my current templates, which you can [download from a link in this Dataview discussion about inline fields being implemented into Live Preview](https://github.com/blacksmithgu/obsidian-dataview/discussions/728).

I deliberately limited the number of items that I track (gratitude, desired outcome, highlights, disappointments, to improve, top notes and top sources), but it is easy to delete or add new items.

I made sure that the journal reflections are linked well to their related sibling, higher and lower time points, for example

- the daily note links to - yesterday and this week
- the weekly note links to - last week and this month
- the monthly note links to - last month and this year.

If you are using a system like arminta’s using inline queries, having them work in Live Preview is probably a feature you need, so please give an upvote or comment with suggestions on the github page above.

I hope my templates are helpful, and I am interested in other people’s use cases and feedback.

---

<div class="post-metadata">

**Author:** ![Saorsa](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/s/45deac/32.png) [@Saorsa](https://forum.obsidian.md/u/Saorsa)\
**Post date:** [January 8, 2022, 3:54am UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/17 "2022-01-08T03:54:27Z")

</div>

Your templates are awesome!! I was trying to make some based on PPV and they just looked some messy. These are so clear and uncluttered. Thank you so much for sharing.

I do have a question though. I could not find where the yearly theme was supposed to be put. I found it in the Monthly note, but not in the Yearly.

---

<div class="post-metadata">

**Author:** ![dryice](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/d/9f8e36/32.png) [@dryice](https://forum.obsidian.md/u/dryice)\
**Post date:** [January 9, 2022, 9:00pm UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/18 "2022-01-09T21:00:26Z")

</div>

You’re right, it’s not there - thanks for letting me know, I’ll update it.

---

<div class="post-metadata">

**Author:** ![Saorsa](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/s/45deac/32.png) [@Saorsa](https://forum.obsidian.md/u/Saorsa)\
**Post date:** [January 9, 2022, 9:06pm UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/19 "2022-01-09T21:06:57Z")

</div>

Another thing. What is this section supposed to me showing from each daily note.  
**Top Sources** ::

- _This week my journal linked to these Top Notes_: -, -, -, -, -, -, -
- 
  - 
### Unable to find section #Journal in 2022-01-02

- 
  - 
###### Journal

- 
  - “2022-01-04#Journal” is not created yet. Click to create.

- 
  - “2022-01-05#Journal” is not created yet. Click to create.

- 
  - 
###### Journal

- 
  - 
###### Journal

- 
  - 
###### Journal

---

<div class="post-metadata">

**Author:** ![dryice](https://forum.obsidian.md/letter_avatar_proxy/v4/letter/d/9f8e36/32.png) [@dryice](https://forum.obsidian.md/u/dryice)\
**Post date:** [January 9, 2022, 9:20pm UTC](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021/20 "2022-01-09T21:20:19Z")

</div>

Yeah that’s not a finished idea!

I like the idea of filtering my favourite original notes or sources from things I’ve read, watched, listened to etc into Top Notes and Top Sources fields.

Then at any point if I want to remember what I wrote that was important in any week, month or year, e.g. September last year, I can quickly write an inline for `=2021-09.top-notes`.

This will be cleaner when dataview is able to access outlinks within my daily note’s `## Journal` section/heading, using `=this.days.file.sectionmap["Journal"].outlinks`

Until the update that allows accessing the section in my daily note, I have been embedding my `## Journal` section and copying over links from there. And then I just delete those embeds. It’s not a great solution, but it works OK for now!

Hope that answers your question!

[Next page](https://forum.obsidian.md/t/daily-and-weekly-reviews-dataview/17021.md?page=2)
