What I’m trying to do
I have a collection of notes with some metadata fields such as:
planning-areaplanning-effort
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…:
| Effort | Area | File Link |
|---|---|---|
| A | a | note1 |
| b | note2 | |
| B | a | note3 |
| a | note4 |
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.