Use BASES instead of DataView to get a count of a specific property!?

What I’m trying to do

Hello all,
I am using a DataView query which I did modify for my needs to get a count of the different entries I am using for a specific property of a file…

like

LIST length(rows)
WHERE rating
FLATTEN rating as rating
GROUP BY rating
SORT key asc

Can this be done with the new BASES feature? If so, how?
Thanks for some advice.

Best, Wolfgang

1 Like

I don’t think that’s possible with Bases. AFAIK, Bases’ formulas operate row by row on the properties of a single row (note) and don’t provide any means of aggregating rows (group by, sum, min, length, count, …).

OK. Good to know. Thanks for this reply.

Best, Wolfgang

Grouping is now on the roadmap, so sometime in the near future! Obsidian Roadmap - Obsidian

AHA :grinning_face:
good news! Thanks.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.