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.
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, …).