You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I store notes in Obsidian which have various properties, the frontmatter looks like this:
level_1:
level_2:
title:
I’d like to produce a dataview table consisting of a two-level grouping, such that my data looks like the following (i.e. note Bar has level_1 = A, level_2 = B, and note Boz has level_1 = D):
Level 1 Level 2. Title
| | wax
| B | zfr
A |--------------------
| Z | Bar
| | hjg
-------------------------
| S | rfa
D |--------------------
| X | oap
-------------------------
I have seen a (small-ish) number of references online purporting to solve this, but cannot get any of them to give me what I want.
This is the sort of thing I’ve been trying, but it doesn’t group by l1 or l2 correctly (only one l1 is shown and all l2s are show whether or not they ought to be hidden):
TABLE without id
level_1 as "Level 1",
rows.rows.level_2 as "Level 2",
link(rows.rows.Title, Title) as Title
GROUP BY "Level 2"
GROUP BY rows.level_1
Can you write a dataview query to give me what I want?
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I store notes in Obsidian which have various properties, the frontmatter looks like this:
level_1:
level_2:
title:
I’d like to produce a dataview table consisting of a two-level grouping, such that my data looks like the following (i.e. note Bar has level_1 = A, level_2 = B, and note Boz has level_1 = D):
Level 1 Level 2. Title
I have seen a (small-ish) number of references online purporting to solve this, but cannot get any of them to give me what I want.
This is the sort of thing I’ve been trying, but it doesn’t group by l1 or l2 correctly (only one l1 is shown and all l2s are show whether or not they ought to be hidden):
TABLE without id
level_1 as "Level 1",
rows.rows.level_2 as "Level 2",
link(rows.rows.Title, Title) as Title
GROUP BY "Level 2"
GROUP BY rows.level_1
Can you write a dataview query to give me what I want?
Beta Was this translation helpful? Give feedback.
All reactions