I’m a perfect newbie in Obsidian, although I’ve been working on a Zettelkasten for a few years now. In comparison, Obsidian is opening up a whole universe of possibilities: simple text files analyzed by frightfully powerful features is an ideal combination. No more will my thinking be prisoner of inscrutable data structures, as it was with another software.
I’d like for now to exploit the metadata analysis features of DataView, starting with a very simple query: I have lots of articles quotes, in their own subfolder, all tagged with “#Article”. Another metadata field, “Source”, identifies the newspaper or news outlet the article is from.
YAML sample entry, with irrelevant data omitted:
--- Created: <date> Modified: <date> title: <title> tags: [<many other tags>, "#Article"] Source: Washington Post ---
I’d like to create a table of news sources, sorted by decreasing number of occurrences, just to have an idea of my news diet. Sounds despairingly simple, but I’m still stumbling.
Here’s my DataView code so far :
TABLE length(rows.Source) AS "Count" FROM #Article SORT Count DESC GROUP BY Source
The table output does lists sources and their number of occurrences correctly, but by alphabetical order of source, not descending count order, as expected.
What am I doing wrong? I feel like an utter imbecile…
All plugins are up to date.
Thank you in advance for your help!