Buying Cycles for Products

[#1]

I have been asked to examine the Buying Cycles of all of our 6000 plus clients and the 10 products we offer them.  I was wondering if any has any good ideas on how to approach this massive under taking because each of our products could be sold on a different date, sold all on the same date, some on one date and some on another date.  Any thoughts or ideas would be awesome.

David

[pablolabbe]

Are you trying to know how often customers buy your products ?

Pablo

[#3]

Pablo,

That is one thing but I also want to see if someone bought lets say 5 products today how long is it before they purchase the next item.  Looking at different trends. 

[#4]

Just throwing some thoughts out there.

Using Peek() or Previous() function you can calculate the difference between two dates on the backend and on the front end create a trend chart with Customer and Product as the dimension and #of Days as the expression.

You can also have a calendar at the top from which the users can select a particular month and do their analysis.

Thanks

AJ