Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi!
I have the following task - count only those clients, who were active in current month AND made their first order in the same month. In particular, i need to build a formula where current month is compared with the 1st purchase month.
This is simplified example, as i have a lot of clients and periods in my original datamodel.
I know set analysis is calculated once per chart disregarding dimension value per row, but maybe there is a workaround?
Thank you!
count( {< Client = p(<Month = 1stPurchase >) >} Client )
@ziabobaz Could you please provide some data sample on this ? Let me see if I can help you in anyways. Thanks.