Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me to define Cust IDs based on Sales Date range. Please find the source data.
EX:
<= 1 Year = Active
>2 Year = Less Active
>3 Year = Attention
May be this
Table:
LOAD [Cust ID],
[Sales ITM],
[sales date],
If([sales date] >= AddYears(Today(), -1), 'Active',
If([sales date] >= AddYears(Today(), -2), 'Less Active', 'Attention')) as Flag
FROM
[..\..\Downloads\Inventry.xlsx]
(ooxml, embedded labels, table is Sheet1);
May be Buckets or Nested IF Statements
May be this
Table:
LOAD [Cust ID],
[Sales ITM],
[sales date],
If([sales date] >= AddYears(Today(), -1), 'Active',
If([sales date] >= AddYears(Today(), -2), 'Less Active', 'Attention')) as Flag
FROM
[..\..\Downloads\Inventry.xlsx]
(ooxml, embedded labels, table is Sheet1);
Try like:
if(age(Today(), [sales date])<=1, 'Active',(if(age(Today(), [sales date])<=2, 'Less Active', 'Need Attention'))) as Flag