Possible to count number of completed and uncompleted tasks without JS?

[blackpeasy]

I want to count the number of completed and uncompleted tasks in each note to show a completion progress percentage.

Intuitively I would type something like sum(file.tasks.completed=true) but it only returns: "false".

Any ideas?

[blackpeasy]

After a real struggle, I seem to have found a solution, and wrapped it all up in a progress bar:

("<progress value="+number(replace(string(sum(number(split(replace(string(replace(string(file.tasks.fullyCompleted), "true", "1")), "false", "0"), ",")))), "null", "0"))/length(file.tasks)+" max=1>") as Progress

[blacksmithgu]

I am impressed and mildly horified by this... is there a function that would make this easier to compute?

[blackpeasy]

Yeah it would be a shame to call it an elegant workaround... My issue is that I had to map "true" to "1", "False" to "0" and "null" to "0", then converting them back to a string every time.

I had a chat with mnvwvnm, who seems to have found a more tolerable solution:
"<progress value='" + (length(filter(file.tasks.completed, (t) => t = true)) / length(file.tasks.text)) + "' max='1'></progress>" AS Progress