How to Build Dataview Powered Dashboards in Obsidian

[@creadevlabs]

What would you like to learn how to do in Dataview?

[@AprendeAEntrenarPR]

I’d like to track workout data because i track cycles and would like to see how things progress throughout a year (macro cycle).

[@creadevlabs]

That's awesome! In particular, are you looking to track how many reps of an exercise you do, how many days you worked out, etc? I've got some ideas of how this can be accomplished 😁

[@AprendeAEntrenarPR]

Yes! I program based on weekly, monthly, yearly scales. so I’d like to see progress with exercises (reps, total time under tension, how long I spent on a given progression) over those spans of time. some of the exercises are time based, rep based, some are bodyweight where as others are with weight. what has been a hurdle for me is figuring out the syntax needed to then query. (not to mention the query itself 😂)

[@creadevlabs]

@@AprendeAEntrenarPR Sounds like an interesting challenge! I would need to know more specifics of how you're recording and storing your data in order to help with queries. Do you have different notes where you track each of the types of data? Are you wanting charts to visualize your data as well?

[@AprendeAEntrenarPR]

I have templates for gymnastic strength training and jiu jitsu, for example. as for the folder structure and how i record, I have: Logs / GST / 2024 / 11 / 2024-11-18.md, 2024-11-19.md, etc. I track a certain group of exercises and break them down by category (Warm Up, Weighted Mobility, Handstands, Front Lever, Bridge, etc), count reps over time (weekly, monthly, quarterly, yearly) time under tension over time, on exercises like squats, the progression of increasing weight over time. where it gets a bit confusing for me is that I want to track occurrences and values. a micro cycle is a week, a meso cycle is a month, a macro cycle is a year. these are the scales I use so it’d be cool to generate a yearly plan and use this dashboard to see it at scale, over time and make adjustments based on the trends.

[@joemoss5138]

Thanks. This was very practical for those starting out.

[@creadevlabs]

You’re welcome 😁 I’m glad it was useful to you.

[@kindry-n7p]

Thank you, this is the clearest video I've seen about dataview! Will you do a video on templater plugin in the future?

[@creadevlabs]

Thank you! I'm glad the video was clear. I want to lower the barrier to entry on some of these more complex plugins, like Dataview and Tasks. I haven't used Templater much, but I'm happy to give it a go! And if I like it, I will definitely make a video about it 😁

[@ManVorOrange]

Great video for beginners! Knowledge of SQL helped me a lot to master Dataview, and for those who don't know, this video will be very useful. Thanks for the great videos!

[@creadevlabs]

Thank you! I’m glad you found the video helpful 😁 My goal is to make Obsidian as easy to jump into as possible.

[@realaroice]

really love your videos sir! 💌

[@creadevlabs]

Thank you! I’m glad you’re enjoying them 😁

[@deserthorsedude]

I agree with you that remembering the syntax for dataview queries is difficult. I think this indicates that the dataview syntax is not very intuitive and should be completely rethought out.

[@creadevlabs]

The syntax is very much based on SQL queries, which I’m guessing a lot of people are not familiar with. I hope providing templates for the queries can lower the barrier to entry for people.

[@San9ASB]

"Dataview: No results to show for list query." ? what is the reason of this ?

[@evraya1]

I wonder about interactive views and automations, like when I tick this, it bells here and whistles there, unfortunately Dataview wasn't intended for the purpose

[@creadevlabs]

What kinds of bells and whistles would like to see with Dataview?

[@evraya1]

@@creadevlabs like I tick Done on a Task type and it changes Closed on the Order type(bind to this task) and sends notification to the Telegram client

[@creadevlabs]

Ah, I see. You're wanting a sequence of actions to be triggered based on an initial action. Yeah, Dataview isn't meant to do that. It makes me curious if there are other plugins that do add that kind of functionality. Time to do some research!

[@uuoocl]

@@creadevlabs Thanks for this tutorial, very helpful! An idea for creating automations. Use dataview to create a list of items as external links that point to Apple Shortcut scripts. Something like ' elink("shortcuts://run-shortcut?name={shortcut Name} &input=text&text={input for shortcut}", "item name")' . Clicking a link would trigger a Shortcut. Apple Shortcuts can send messages to telegram and many other destinations.

[@realaroice]

can we connect!

[@creadevlabs]

Are there questions you have that I can help answer?