I have a database containing the sales of our products by account and by product name by month. What I have been asked is whether it is possible to label or categorise accounts that have not bought anything (null sales) within a defined amount of time.
The measurement needed across all accounts and all individual products using the following rules:
1. If the account has not bought the product within the last 2 months then label 'amber'
2. If the account has not bought in the last 3 months or longer then label 'red'
What is the best approach for something like this?