Write your own SQL in Dataset Views

jaeW_at_Onyx

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 aggregation settings (hopefully you didn't rename any columns!)