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.

[@ПавлоВ-о3ъ]

another new way I've learned. Thank you.

[@creadevlabs]

You're welcome! Thanks for watching 😁 I hope it was useful to you.

[@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.

[@josephlam7088]

Thanks

[@creadevlabs]

Wow, thank you so much!

[@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 😁

[@joemoss5138]

Thanks. This was very practical for those starting out.

[@creadevlabs]

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

[@realaroice]

really love your videos sir! 💌

[@creadevlabs]

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

[@maksadTohBhoolChuka]

hey is there a way in obsidian to have tables like what we have as lists in slack channels ? Basically a table where a column can have datartypes like date, select dropdown, checkbox, etc.

[@creadevlabs]

You can put checkboxes in tables, but that's about it. Tables in Obsidian are fairly limited due to everything being based on Markdown.

[@EllisBooker]

One dataview trick I'm trying to get working is to display the content under a heading. I can create query that provides a list or table with all the notes containing the heading, say, "Daily Summary" but how do I display the stuff under the heading as part of the query?

[@creadevlabs]

I don’t know if that’s possible or not. I’ll have to experiment with that.

[@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.

[@creadevlabs]

Ooh! That's an interesting idea. That's something I'll have to experiment with. Thanks!

[@lovetheentertainment9949]

Can you please create a proper play list of videos from zero to hero of obsidian I don't know nothing about obsidian when I see your playlist I feel the videos are jumbled in unordered way. Please help me out

[@creadevlabs]

I’ve got a video where I combined several of my Obsidian for Beginners videos into one: kzbin.info/www/bejne/nZLJpqSagNx3lbcsi=zv6OVvxhA0tdcSuJ I’ve also got an Obsidian for Beginners playlist you can go through: kzbin.info/aero/PLsntwn2ixQrOpEEkE8SMj1X4Kf-cOIVgD&si=-HxSEsou0h4J3jKs Let me know if you have any questions!

[@San9ASB]

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

[@creadevlabs]

That means your query is written correctly, but there are no files that match the criteria.

[@realaroice]

can we connect!

[@creadevlabs]

Are there questions you have that I can help answer?

[@lovetheentertainment9949]

Hi, 👋 I had gone through your first obsidian basic course, not getting time to spend on the rest of the videos. can you please create a video on how to take notes quickly using a method. Recently I saw this video kzbin.info/www/bejne/amWYqquQl89nfpYfeature=shared I liked his organisation of taking notes using para method But couldn't understand his explanation of taking notes as it is too fast and difficult to understand Just have a glance on the above video, Can you please make a clear video on how to take notes perfectly linking and with less duplication of content, templates, data views etc, organizing etc

[@creadevlabs]

Are you looking for a video talking about quickly capturing notes, and not worrying as much about the organization?

[@lovetheentertainment9949]

@creadevlabs quickly capturing notes in an organized method like para as shared in the video above

[@creadevlabs]

Gotcha. That's something I can totally make a video about 😁

[@lovetheentertainment9949]

@@creadevlabs Hi buddy please make a video on what i suggested new year is coming still don't know how to capture notes with organizing

[@creadevlabs]

I usually take a break from making videos during the holidays. I’ll be starting up again in a week or so. I also have lots of video ideas in the queue, and I’m not sure yet when I’ll be able to make this particular video. Are you wanting to use PARA in particular? If so, I’d recommend checking out Tiago Forte’s channel as he is the creator of PARA, and you might be able to find what you’re looking for faster that way.

[@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.