How to write a query with a specific range and the group by clause

I have an ecommerce site.
I basically have to get the list of pages along with its page view count over a specific period of time.

So i have to have a query with a GROUP BY of only the ‘Page name’ and specific date range.

Can someone please help

Can you give some data sample? As I tried to explain in this post: it is something complex to do since the range query is reading the full index and we read the startkey from left to right only (as a full key)

This is one of the reason we are building a more powerfull query engine that is available as developer preview:

And you can even test it online:
to see what could be done