Clarifying:
1 - in each group (by folder) sort the files order?
2 - see the file.link but instead of the sort by the file the sort by the file.size?
3 - sort file.size by ascending size or descending?
thanks for the message!
1: yes like : group1: {el1,el2,el3} where size(el1) > size(el2)
2: yes - I dont mind having both - but when I tried with list it was sorting only one of those.
3: desc
LIST rows.fileSize
FROM "6.Projects"
WHERE !contains(file.folder, "_Archive") AND !contains(file.name, "_Working on")
FLATTEN file.link + " (" + file.size + ")" AS fileSize
SORT file.size
GROUP BY file.folder