Write your own SQL in Dataset Views
It would be ideal to be able to write your own SQL in the Dataset Views UI. The process for defining views can be very slow especially if you want to add a calculated aggregated column AFTER you've applied the GROUP BY clause -- because you'd have to ungroup the VIEW, define the calculated column, then reapply the…