I would like to have a summary view of daily tasks - identify productive/unproductive days by counting checkboxes of each state in daily notes.
This might be a good idea for a plugin, but first I wonder whether something like this can be achieved with dataview or by other existing means.
Reference: how tasks are counted in GitHub issues containing checkboxes.
Except, ideally, I would like to have this information collected in a list/table like this:
I don’t need a progress bar, I need one symbol per task.
While figuring out how FLATTEN works, I came to conclusion it is not what I need, and even if there is a roundabout way to use it, it might be not the best idea.
At the same time, I realized DQL can do this:
TABLE
join(sort(choice(file.tasks.checked, "✔", "❌")), "") AS "Tasks"
FROM "journal"
(This way of implicit array handling is not something present in languages I use daily. Convenient for data processing but unsettling.)