#37

Obsidian is not FOSS and is the same as Notion for all intensive purposes as far as licensing goes.

#38

Hi, you could also try eliminating files from your template folder. That way you can use this same line for all of your Dataview recipes.

for example, I exclude my templates folder using: !"System/Templates"

#39

I think she is using a field Completed:: and if it is marked 1, then it is completed.

#40

Yes, You are right.

#41

Thank you @armint, for typing out your workflow here. I’m currently trying to do something similar, and I have a question for you.

If I understand your setup correctly, you have a note for each project, which contains the Dataview query to get the task notes associated with that project. What I don’t get is the “Projects” overview page. In your code example, you query length(tasks) as Total, for example. If I try to reconstruct this, the tasks variable is empty. I assume that is because the project page does not actually have tasks written in the note, but uses Dataview queries to get them from other pages.

Any help with this?

1 Like
#42

Hello @armint,

I’m facing the same issue as @Joern. Is you clever workflow still working with latest Dataview (0.4.5)?

Thanks and regards

#43

For anyone if they stuck at length() function not working to get the progress show, I stuck the same question like you, and use the group by syntax to get the similar result, hope it can helps you.

table length(rows) as total, sum(rows.completed) as completed, sum(rows.completed) / length(rows) * 100 + "%" as Progress, rows[0].file.link as Next
from #tasks
sort file.mtime asc
group by project

if anyone know the answer why my length() is not working (seems like I am not only one meet this problem), please let me know.

#44

Fabulous resources @arminta!
Quick question here: Under available tasks and completed tasks, I keep getting this error.

Any guidance on how to fix this? Thanks!

Dataview: Every row during final data extraction failed with an error; first 3:

            - Operator '/' is not supported for 'null' and 'number
- Operator '/' is not supported for 'null' and 'number
#45

The only way I got the Projects dv to populate with
@arminta’s code above was by adding more than 1 task as a [[]] on the individual project template in the tasks:: field

#46

I too am getting a similar error in Dataview, it just started happening in the last 24hours:

Dataview: Every row during operation 'where' failed with an error; first 3:

            - Operator '+' is not supported for 'null' and 'number

If you find a solution @Keys , I’d appreciate a ping.

@blacksmithgu or @Moonbase59 have you any ideas what is going on here? (I pinged Matthias as, in my case it is your ‘upcoming birthday’ script that is no longer working for me).

1 Like
#47

No luck on my end. Couldn’t find a fix anywhere. Looking forward to seeing if you find out anything

#48

do you need to write a time value - e.g. recur length:: 7 days

#49

Besides all the useful information in this thread: @arminta , may I ask which theme you are using in your first post? Looks very refined and focused.

#50

This is such a great example.

I’m keen to hear if/how anyone has implemented task scheduling into #mermaid gantt chart OR into the Daily Planner / #daily-note
This would aid in bringing it visually to life.

1 Like
#51

Hey @arminta,

Sorry, I’m kind of newish to Obsidian plugins.
For the above snippet, where do I add it so that the button shows?

#52

You need to install a community plugin called “Buttons!”

#53

Great inspiration! And for your contribution, I’m sending all positive energy and wishes that back in April “Create $3M” manifested :wink:

#54

Following up on this reply:

Once you’ve added the “Buttons!” community plugin, you make a codeblock beginning with ```button

then paste the code

and end with ```

#55

Hi @arminta , thanks for these examples. I don’t know if you’re still using the same system, and would be curious to learn if you are or how you’ve changed it. In the meantime, I have two questions:

  1. Following up on the same questions here, here, and here— the use of length(tasks) as Total in the dataview for the Projects page. What is tasks supposed to be being populated from?

  2. You have a Tasks:: metadata in your Project template. Do you manually add links to whatever tasks are part of that project? If so, that would mean that you have to both add the Project:: metadata to a new task, then go to the relevant project and add the new task to the Tasks:: metadata, correct?

#56

I’m also very curious to know how length(tasks) is populated.

  • are all tasks individual pages?