Forum Discussion

CIWEB's avatar
CIWEB
Icon for Helper I rankHelper I
8 years ago
Solved

Tracking Customers Year Over Year

Hello I was wondering if anyone had any suggestions as to how I could track a customer ID#, date, and product type, to put together a list of which customer's are returning year after year, and how m...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You may refer to my solution here.

     

    Hope this helps.

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    You have to go to Modelling > New Table and then write that formula in the formula bar.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

 

Share some data (for 5 years atleast) and show the expected result there.

CIWEB's avatar
CIWEB
Icon for Helper I rankHelper I
7 years ago




















So I would like to have it so that if the Mail # appears for five consecutive years for them to be considered Returning. If the Mail # appears between 4-5 times in five years to be Considered Infrequent. When the Mail # occurs for the first time for it to show up as New.

Is this possible?

Thanks!