Drupal Views Falls short by not including aggregation functions and custom group by and distinct options

I've always felt sometihing was missing with Drupal Views. I never identified it while using views but I've always "felt it's presence" - or lack thereof - while building custom queries for whatever reason in MySQL. Every time I added a function like min(), max(), or sum() or tried to aggregate results with 'group by', I've said to myself silently, "I wonder if I can do this in Views.." but never checked it out until now.

Subscribe to RSS - distinct