Forum Discussion

CIWEB's avatar
CIWEB
Helper 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
Super User
8 years ago

Hi,

 

You may refer to my solution here.

 

Hope this helps.

 

CIWEB's avatar
CIWEB
Helper I
8 years ago

Thank you I think that should work, however I am getting an error with computing the date. I typed 

Date = CALENDAR(MIN(Data[Purchase Date]),MAX(Data[Purchase Date]))

and I am getting an error of

"A table of multiple values was supplied where a single value was expected."

Any idea what is causing this error?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

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

    • CIWEB's avatar
      CIWEB
      Helper I
      8 years ago

      Thank you so much for the help! That did it

    • CIWEB's avatar
      CIWEB
      Helper I
      8 years ago

      Would it also be possible to calculate the average number of tickets sold to the customers? As a measure it looks like I can not just have it average in a visualization like I was hoping. Would it also be possible to determine something like "55 customers purchased between 0-2 tickets in 2015", "65 Customers purchased between 2-4 Tickets in 2015"?


      Thanks so much for the help.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        I think this would entail writing individual formulas for each interval that you want to study such as 0-2, 2-4 etc.