Frequency of sales

[bmenicucci]

Hi guys,

I'm trying to find out, for each product, the frequency of sales, e.g. I would like to know that I sell a unit of product every "x" days (on average).

Any idea on how to do that?

Thanks a lot in advance!

[Gysbert_Wassenaar]

try: interval(max(salesdate)+1-min(salesdate))/sum(units)

[bmenicucci]

Hi Gysbert,

thanks a lot for your help!

I've played a while with your suggestion and at the end I've come to a different solution:

interval(vToday-min(salesdate))/count(invoices)

that's why I want to know how many times I've sold a product (the count part of the expression) in a range of time that is from it's first sale and today.

You've been precious!

Thanks again

Cheers