I can not seem to be able to figure out how to do group by aggregations in the ad hoc views. I have a domain defined. The ad hoc views will join tables properly but not allow for any group by functionality.
Say for example you have:
Book sales by hour table.
And you want to display a simple table of aggreage book sales by book over some time period (choose by filters). Is this not possible in the ad hoc views?