Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi. in my work, i'll calculate the percentage of active, passive and lost customers. i'll explain these words:
if the customer's last transaction is in the last 3 months, this customer is active. if the customer has not a transaction in the last 3 months but has in previous 3 months, he is passive. if not both, i say he is lost.
now, i want to calculate 3 numbers: how many customers are active, passive and lost.
in a straight table, i used customer id as dimension, max(date) as expression1. as expression2, if expression1 is bigger than AddMonths(date(now()),-3), i mark it 1, else 0. like that, expression3 is, if expression1 is bigger than AddMonths(date(now()),-6), i mark it 1, else 0. and finally expression4, if expression1 is bigger than AddMonths(date(now()),-12) i mark it 1 else 0.
finally sum of the expression2, 3 and 4 are the goal numbers.
but i wonder, can i calculate the count of customers?
If you can attache a sample app, that may help someone provide some further guidance on this one.
Regards,
Brett