Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Folks,
I'm trying to create a expression to count active customers. I need to present:
My difficulties is related to identifying when was the last purchase dynamically, and the count.
Could anyone help me ?
Thx,
Vinicius
can you please provide sample data?
thanks
regards
Marco
hope to understand,
see attachment
The example, really helps.
But If I understood it rightly, I still miss something.
For instance, the customers I count for last month must not have any purchase in this month.
I have to count the customers which had they last purchase in the period. If I'm counting customers with last purchase 2 months ago, I cannot consider customers who bought on past and current month.
Am I being clear on the idea ?
Could you please help me ?