I'm currently trying to return unique files, counting how many times the file changed. However, I want to order by the file changes decending (Most changes to a particular file at the "top" of the report). This query will give us greater insight on problem areas/code within our code base.
The current query looks something like this, but it fails to parse anything other than "order by date." Would love to be able to order by count(revisions). Is it possible?
Thanks
Sample Query:
select revisions from dir "<some dir path>"
order by date desc
group by file
return path,
count(revisions) as "Total Fixes",
sum(linesAdded) as "Lines Added",
sum(linesRemoved) as "Lines Removed"