Sum over vault with tasks

Help
1

Hey every one! Beginners question with dataview :laughing:

I have multiple meeting notes with tasks i them. In the tasks is array of BT:: 60 with a scheduled date. Looking for a way to get the total of BT grouped by scheduled date.

Tried the following queries:

Totaal planning in minuten:
= round( sum(nonnull(this.file.tasks.BT)), 2) minuten

List 

sum(
nonnull(
dv.taskList.
where(t => t.scheduled = t.date(06-05-2025")))
group by scheduled

const total = tasks.BT.array().reduce((acc, val) => acc + val, 0)


TABLE 
rows.T.text, rows.T.BT, sum(rows.T.BT)
FLATTEN file.tasks AS T
GROUP BY T.schedueled

Can anyone point out the mistake i’m making?

The goal is to get total of BT and check if it is lower than te budget time.

2

Could you show some typical tasks in your setup?

3

Hello,

Try this Dataview query:

TABLE sum(T.BT) AS “Total BT (min)”
FROM “your/notes/folder”
FLATTEN file.tasks AS T
WHERE T.BT AND T.scheduled
GROUP BY T.scheduled
SORT T.scheduled ASC

Use ==, not =, in conditions.

Watch for typos like schedueled → scheduled.

Make sure BT:: is inside each task and recognized.

Best Regard,
Dona