Exercise and workout dataview ideas

[arminta]

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

#workouts

Date::
Type::
Set Type::

Planned RPE::
Sets::
Reps::
Computed Conversion Multiplier:: =choice(this.Reps = 2, 0.97, choice(this.Reps = 3, 0.94, choice(this.Reps = 4, 0.92, choice(this.Reps = 5, 0.89, choice(this.Reps = 6, 0.86, choice(this.Reps = 7, 0.83, choice(this.Reps = 8, 0.81, choice(this.Reps = 9, 0.78, choice(this.Reps = 10, 0.75, choice(this.Reps = 11, 0.73, choice(this.Reps = 12, 0.71, choice(this.Reps = 13, 0.7, choice(this.Reps = 14, 0.68, choice(this.Reps = 15, 0.67, choice(this.Reps = 16, 0.65, 1)))))))))))))))
Conversion Multiplier::

Exercises::

Max HR::
Average HR::
Duration::
Calories::
Distance::

Cardio::
LISS::
Recovery::
Mobility::

Warmup:

Today’s Exercises

table number(master-exercise.one-rep-max) * number(this.conversion-multiplier) * number(this.planned-rpe) as "Goal Weight", Weight, choice(number(master-exercise.one-rep-max) * number(this.planned-rpe) < Weight, "✅", "-") as PR, master-exercise as "Master Exercise", this.sets as Sets, this.reps as Reps, weight/number(this.conversion-multiplier) as "Today's 1 Rep Max"
from #exercises 
where Workout = this.file.link
sort file.name desc

Notes:

Admin

• Update Max Weights if applicable

table master-exercise, master-exercise.one-rep-max as "1 Rep Max"
from #exercises
where Workout = this.file.link
sort file.name asc

name Add Exercise
type note(New Exercise) template
action Exercises Template
class dataview-button

---

table date as date____, pr, master-exercise as master_exercise____, workout as workout____, master-exercise.family, master-exercise.one-rep-max
from #exercises 
where !contains(file.name, "Template")
sort date asc

#exercises

Date::

Master Exercise::
Workout::

PR::

Computed One Rep Max:: =this.master-exercise.rep-max
One Rep Max::

Computed Sets:: =this.workout.sets
Sets::

Computed Reps:: =this.workout.reps
Reps::

Weight::
Goal Weight::

Computed Planned RPE::=this.workout.planned-rpe
Planned RPE::

Conversion Multiplier::
Todays Rep Max::

table Family, one-rep-max as "1 Rep Max", workouts, exercises, muscle-groups
from #masterexercise 
where !contains(file.name, "Template")
sort family asc

---

There are still things that I’m tweaking, but should give you some ideas and I’ll try to update this with improvements I make.

Related:

Daily and Weekly Reviews + dataview

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 mo…

Knowledge Management dataview examples

[Screen Shot 2021-04-22 at 15.11.51] 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 [Screen Shot 2021-04-22 at 14.42.52] #knowledgeTopic Status:: Active Importance:: Goals:: Pillars:: Habits and Routines:: Courses and Training:: Relevant Resour…

Dataview task and project examples

Ok, here are some examples of templates and dataviews for task management: [Screen Shot 2021-04-22 at 14.35.12] 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, Pr…

Dataview for reviewing and processing media

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: [Screen Shot 2021-04-24 at 18.23.59] Here’s the markd…

[Cajun]

I really like the idea, you’ve given me a couple of thoughts that need to percalate a little. Thanks

[MortimerJazz]

Evening ladies and gents - I’m a noobie to Dataview and could do with some help.

I’m trying to figure out how to access the source element from the YAML.

At the moment, I’m using:

```dataview
table 
from "Podcasts"
where contains(file.source, "Tim Ferriss")
```

Have I got this right?

Thanks very much in advance

[arminta]

Try this:

```dataview
table file.mtime 
from "Podcasts"
where source = "Tim Ferriss"

[dr1nk182]

@arminta Interesting in implementing something like this. Did you end up making any changes additional changes after tweaking things?

[Zeltak]

thx so much @arminta !

do the tiny black sort buttons:

do anything (ie sort?) or are they just GUI eycandy?

thx so much

itai

[Pat68]

Hi @arminta
Are you able to share the whole document set ?
I will adapt to my own?
Thanks in advance
Patrick

[dryice]

Sortable plugin https://github.com/obsidianmd/obsidian-releases

[trjlove]

I don’t think she is supporting this any more. I have started to build something, based on this information. It is at detailed yet, but I am continuing to work on it. I posted a video on YouTube. How to use Obsidian to keep a workout log - YouTube

[soyelcharly]

Wow I really love your approach and I’m wondering how can I merge it with my approach.

Let me explain it cause You might be interested.
I have an exercise database. So Using the DB Folder plugin I have a folder with a lot of exercises notes that in it’s YAML it is organized by

• muscle group (hamstrings, shoulders…),
• skill you are working (coordination, balance, strength…),
• equipment needed (rings, dumbell…),
  difficulty (1-5),
• actual status(in my domain, inprogress, next target, out of reach),
• type of activity (calisthenics, capoeira, gym, )

My idea was to register every workout that I do using a macro (as you brilliantly explain) adding some more fields for quality data (like observations about form or posible disconforts that may occur).
I also would love to create a track of every exercise progression in its own note.
So each exercise note has:
the YAML info to classify for the DB folder plugin.

• A descripcion of the exercise and a tutorial for the progression
• A gif(or youtube link) where you can see the movement pattern
• Certain tips or considerations
• A table or query with all the workouts that I work that particular exercise.

If you like my approach we should contact each other, I can share with you my exercise database and you can do your magic and see how can we improve it. Because unfortunately my knowledge in programming and queries is very limited.

I think you can benefit from this perspestive because it focus not only in progressing in a limited range of movements but also in unlocking some new ones.

Keep up with this good work!!!

[emmaamelia]

Oh, That’s great Really i like your database template, I want to ask a question. How do I compile this database for my Business?Actually I am owner of a company that provides online services like exercise and in home care. and accroding to my opinion this database is fit for my business.