How to make complex grouping

[Vovkin]

I have 2 tables - orders and users, where user can have many orders.

What I want to do is to get next data on chart:

 

how many users ordered once, twice, 3, 4, 5 ... times (with possibility to check it by day, month, year)

 

As I see, I need to get number of orders per user by period, and then make grouping by that number of orders. I'm trying to do this with my 2 tables right in Ad Hoc View, but it looks impossible to do this here, without some additional data.

 

Maybe I should add derived table in domain at first or something like that?

 

[elizam]

You are on the right track - you need to connect the two tables somehow in your Domain.  Can you join the tables on a common key field?

[Vovkin]

Yes, they are already joined. But it looks like it's not enough to achieve what I want right in Ad Hoc View. I could only shouw on chart number of orders per user so far, but I need group by and show number of users who made 1,2,3 etc orders.