16 Replies Latest reply: Apr 28, 2015 6:47 AM by Ankita Agarwal

# How to create aging customer by last visit date?

Hi all,

i have a month(december) record, where my client wants to know, how many customer purchased product from him by date 1-6, 7-12,13-18,19-24,25-31. the client also wants to know when was customer A last visit purchase product from him.

all these info , client would like to display it in bar chart.

• ###### Re: How to create aging customer by last visit date?

you can create this range by using class function

class(Date,6)

• ###### Re: How to create aging customer by last visit date?

what is that 6 for?

• ###### Re: How to create aging customer by last visit date?

the 6 is the size of the range the function will use

• ###### Re: How to create aging customer by last visit date?

Kindly prefer the attached application

• ###### Re: How to create aging customer by last visit date?

nicely done bro.! i have a question, is there a way to change 0<= x < 6 to 0-6 ?

• ###### Re: How to create aging customer by last visit date?

Hi Fuan,

you can add a custom label as a parameter to the class function

Class(Day(Date),6,'Label')

but you can't remove the <= < I'm afraid

Joe

• ###### Re: How to create aging customer by last visit date?

i wonder, i am sure there is difference between intervalmatch and by using class. right?

can we use intervalmatch for this case?

• ###### Re: How to create aging customer by last visit date?

Hi

Try like this

Replace(class(Day(Date),6),'<= x <','-') as Dim

• ###### Re: How to create aging customer by last visit date?

nice. 0-6 now.   but i have just edited with line Replace(class(Day(Date),6),'<= x <','-')

• ###### Re: How to create aging customer by last visit date?

Write the expression as

==Replace(class(Day(Date),6),'<= x <','-')

And I m sis not Bro

• ###### Re: How to create aging customer by last visit date?

i am so so so sorry , sis! you r awesome! thanks anyway!

• ###### Re: How to create aging customer by last visit date?

Sis,

I think using class has no issue solve this case. What if --- the client said, he wanted instead of 30-36, he wants it to be label as "Last Visit" , can i do that in Class function?

• ###### Re: How to create aging customer by last visit date?

Lemme check!

• ###### Re: How to create aging customer by last visit date?

Bro!

I don't think we can do that.

• ###### Re: How to create aging customer by last visit date?

Hi

PFA

• ###### Re: How to create aging customer by last visit date?

I thought Fuan wants to create the range at front end and not in the script. At front end it is not possible