Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

NEW and Existing Customers

Want to calculate New and Existing Customers based on first activity date of customer. When I select calendar fiscal year and quarter then First Activity date of Customer which lies in that fiscal_year and quarter can show as NEW and before selected period and after selected period it can show me Existing.
Example :

 


Below is my data model