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?