What I’m trying to do
I have a collection of notes with some metadata fields such as:
The fields themselves are independent and not nested. So a given note can be in any combination of “planning-area” and “planning-effort” values.
I want to have an overview that shows me notes organized by planning effort, but with each area/note shown as their own row (sorted by effort/area/file), e.g…:
Things I have tried
I can get the data to display, but it is structured incorrectly.
## T1 \```dataview TABLE WITHOUT ID rows.Effort, Area, map(rows, (r) => r.rows.file.link) as File WHERE planning-effort GROUP BY planning-effort as Effort GROUP BY rows.planning-area as Area \``` ## T2 \```dataview TABLE WITHOUT ID planning-effort, rows.planning-area, rows.file.link WHERE planning-effort GROUP BY planning-effort SORT planning-area \```
It would also be really nice to actually group on the second field (
planning-area), but I think that might be beyond what we can do easily.