thank you @holroy and @Craig appreciate your efforts 
I now have a new issue to solve 
namely, changing all "-"s to zero and all the previous labels that I used for Minutes’ for more than 2 years of daily notes
Do you have any ideas on how I could complete that task without doing it manually, perhaps using a Python script?
This is kind of the culprit, whenever it’s not a number, which the previous queries kind of has led up to. Regarding how to handle it, you’ve got basically two options:
minutes (in over 2 years of files worth)minutes from the queryAlternative 1 is of course the political correct way of doing it, but it’s a hassle, to say the least.
Alternative 2 is far easier, but it comes at the cost of potentially hiding some rows, which you kind of would like to include. But given the other queries, let’s go for this version, and it is actually simpler than you’d think it be, as we just need to add typeof(minutes) = "minutes" to the where clause.
So here is the full query, where it simply ignores all the erroneous minutes values:
```dataview
TABLE WITHOUT ID Count, Tot, Avg, Min, Max
FROM "Archive 🗃️/Journal 📅/Days"
WHERE MONTH = [[2023-Jan]]
WHERE minutes AND typeof(minutes) = "number"
GROUP BY ""
FLATTEN length(rows.minutes) as Count
FLATTEN sum(rows.minutes) as Tot
FLATTEN Tot / Count as Avg
FLATTEN min(rows.minutes) as Min
FLATTEN max(rows.minutes) as Max
```
Hope this helps, and that the process to get here has been educational.
I hadn’t thought of verifying the type of the field. Good thinking! 
I’ll definitely go for Option 2, since I’ve no need to check summary statistics for previous years
It was really beneficial to see the process and how it all worked out, it was also a good reminder of the importance of learning dataviewJS.
As JavaScript is such a huge area of study, can you recommend some good resources for me to learn from? I’m not looking to learn the entire language, just enough to be able to write more powerful dataview queries.
Any advice would be greatly appreciated.
Thank you!
Well, you could take a masters degree in Computer Science, and work with it for a few decades, and stumble across javascript every now and then, and see where that takes you… 
Or you could just keep playing around with it, copying code which looks useful, and start tweaking it to your needs. Not sure on which are the better resources for learning javascript today, but there are loads of dataviewjs queries floating around in this forum, which maybe could help you learn more of it.
Darn I really willl have too juggle with it, same way I did with dataview, which isn’t the most effective learning process but…
As someone who loves class-based languages, this makes me sad
It’ll take work, but then again if you ask questions which show what you’ve achieved so far and trying to achieve, and as such indicate that you’ve really tried to get it working, I think you’ll experience that those more familiar with the language will easier tend to help and guide you in the correct direction.
Nothing kills my spirit and helpfulness more than someone just saying: “Hey, can you do this for me?” or “This auto-generated ChatGPT code doesn’t work, how to fix?”. When I see a proper attempt from someone trying to get something done, I’ll more often step in to try and help.
Just as a point of clarification (and please forgive me if you already knew this), Dataview and DataviewJS are two very different but related things.
Everything we’ve discussed in this thread has been about the Dataview query language, which is an SQL-like language specifically for running Dataview queries. It’s (arguably) easier to use and more focused than DataviewJS, and is a great place for people to start learning about structured data in Obsidian.
DataviewJS is an environment for running plain JavaScript in your pages, with access to the Dataview libraries so you can do things like query, filter, etc. It’s more powerful than Dataview, but also far more complex and more time-consuming to learn. It’s a better fit for folks who already know Javascript and want to take advantage of the Dataview libraries.
Having said that, if you’re interested in learning either or both, go for it! But I’d recommend getting familiar with the Dataview query language first before diving into DataviewJS.
This is indeed very useful @Craig, I was assuming that I need to learn dataviewJS in order to take full advantage of dataview.
Surely was feeling a bit intimidated by all the amazing things people can do with dataviewJS, but it’s great to know that I can still take advantage of dataview without the need to learnd dataviewJS.
I think I’ll focus on the functions where I’m still lacking.
Going back to the queries, I have 2 new questions now.
We were summarizing one particular field from the front matter, which is not the only one I’m tracking in the daily note. Let’s say I’m tracking 5 fields, with the previous approach, I’d need to create 5 different tables.
Is there a way to group them within a table? I believe the group by function can help, but this has been really confusing for me to master
Facing a new challenge…
One thing that I track is wake_up and end_by time. I input these in the form of 6:00, 20:53
By using the previous dataviewjs query I figured out that Obsidian read such entries as string. Hence I believe I have to convert them into numbers and then summarize them.
By looking at the Dataview documentation I figured out the number() and split(string) function could help, but honestly no Idea how to integrate them in the query that summarize results
`
`
I’m also open to suggestions on different tools to manage this type of information, but for me nothing beat having everything centralized in one place and data priavacy 
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.