Reporting Row Groups - Sort by Count Instead of Field Value

Now that we can view over 10,000 records when opening a report in ADMM, we can start to get value and drive data analysis using using the 'row groups' functionality. One thing that would be very helpful here would be able to sort by the count, rather than just the text value of the field you are grouping by. This would make it so easy to see highest impact for whatever you are looking at. Right now, if you have more than a dozen or two unique values you are looking at, it becomes very hard to see the highest and lowest values and I end up going back to SQL almost all the time as a result. This functionality is super close to being amazing in ADMM - let's get it all the way there!

In addition, if you are grouping by a field that you had to scroll to the right horizontally to find, when you drag it to the group the screen should bring you back to the left. What happens right now is your horizontal position stays fixed, and you end up with a completely blank white screen and it's hard to understand what the heck just happened. When we are grouping, we should go back to the left to make it more intuitive for users and show them the result right away.