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.
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)" ?
