Tracking time and rolling up sums based on substring matches

[neeldhara]

I am tracking my time in Obsidian, and each log is a separate file where the metadata contains the duration of the activity and a list of categories separated by "|" that the activity belongs to. I can use this:

dv.paragraph("Total time spent on XYZ: " + dv.pages().where(t => t.category == "XYZ").hours.array().reduce((acc, val) => acc + val, 0).toFixed(2) + " hours.")

to get the total time spent on activities that match category XYZ. However, this works only when the category field is an exact match with XYZ. I also want to capture those log files where the category contains XYZ, but I am not able to adapt this snippet to work in this setting.

Any advice would be greatly appreciated!

[AB1908]

t.category.includes()? Can you share some metadata as well?

[neeldhara]

Unfortunately .includes("XYZ") does not seem to work :(

Here's sample metadata:

---
activity: YouTube
start: 24-Jun-2022 at 00:00:00
end: 24-Jun-2022 at 01:30:00
duration: 01:30:00
hours: 1.5000000
category: Chill
note: 
---

and

---
activity: Organising
start: 24-Jun-2022 at 01:45:00
end: 24-Jun-2022 at 02:15:00
duration: 00:30:00
hours: 0.5000000
category: Personal|Neutral
note: 
---

If I try saying category.includes("Neutral"), it gives me the following error:

Evaluation Error: TypeError: Cannot read property 'includes' of undefined
    at eval (eval at <anonymous> (plugin:dataview), <anonymous>:1:110)
    at Array.filter (<anonymous>)
    at Proxy.where (plugin:dataview:9407:39)
    at eval (eval at <anonymous> (plugin:dataview), <anonymous>:1:88)
    at DataviewInlineApi.eval (plugin:dataview:19536:16)
    at evalInContext (plugin:dataview:19537:7)
    at asyncEvalInContext (plugin:dataview:19547:32)
    at DataviewJSRenderer.render (plugin:dataview:19568:19)
    at DataviewRefreshableRenderer.maybeRefresh (plugin:dataview:19169:22)
    at HTMLDivElement.r (app://obsidian.md/enhance.js:1:9415)

Also attaching a screenshot for reference.

Thanks for taking a look!

UPDATE: apparently

.where(t => t.category && t.category.includes("XYZ")

does it! So .includes() like you said, but I wasn't using it properly... thanks again!

[AB1908]

Ah yeah, we missed null checks. I tend to forget those at times haha.