Hi,
I have a table that shows me orders sorted by order month.
orderdate | orderamount
==========================
03/09 | 1000
04/09 | 2000
05/09 | 1000
I have a second table with customers. Customers have a datefield that shows me when they
became customers. I'm doing a count on this to get the new customers by year.
customer_id | customerdate
==========================
1 | 03/09
2 | 04/09
3 | 05/09
It's possible that customer became customers in e.g. april and their first order was in may.
I would like to show both information (orderamount and count) in one table. I know that there's the option to concatenate these tables or creating a calender and use this field. Let's say this isn't an option 😉
Is it possible to add the count to the first table (I know this isn't correct). Is there a way to get the count "independent" from the dimension (and do something like "count( if customer_date = orderdate)" ?
Thanks for your help.
Regards
Elzo