Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Below is the scenario:
I need to identify new customers for the selected current month , comparing them with the values of previous month.
eg: if 01/01/2018 has customers - a1,a2 and month=01/02/2018 has customers- a2,a3 .
if i select month=feb , the new customer name i.e a3 should be displayed in straight table.
Thank You in advance !
Below are the solutions that worked for this situation :
Backend:
Created a flag using
load
Month,
Customer,
if(Previous(Customer)=Customer,'Old','New') ascc
resident table
OrderbyCustomer,Month;
and straight table dimension
=if(cc='New',Customer)
FrontEnd:
Dim=if(not isnull(Month),Customer)
Exp1- =count(DISTINCT Customer)
Exp2-=if(Count({<Month={'<$(=max(Month))'},Customer=P({<Customer>})>}Customer)>0,'No','Yes')
Hello!
You can use Left Join with addmonths(*, 1) for such tasks:
All that is null is a new customer.
Below are the solutions that worked for this situation :
Backend:
Created a flag using
load
Month,
Customer,
if(Previous(Customer)=Customer,'Old','New') ascc
resident table
OrderbyCustomer,Month;
and straight table dimension
=if(cc='New',Customer)
FrontEnd:
Dim=if(not isnull(Month),Customer)
Exp1- =count(DISTINCT Customer)
Exp2-=if(Count({<Month={'<$(=max(Month))'},Customer=P({<Customer>})>}Customer)>0,'No','Yes')