topic Re: Find Average Days Between multiple deliveries in Alteryx Designer Desktop Discussions

Find Average Days Between multiple deliveries

BretPinkerton — Wed, 22 Apr 2020 16:54:32 GMT

Hello

I am trying to find the average number of days between deliveries of each outlet and product combo. So if I have 4 deliveries recorded for an specific outlet and product combination in my data set. Then I would calculate the days between each of the deliveries, then average them.

Any help would be appreciated.

Deliveries	Days Between Deliveries
11/1/2019
12/15/2019	44
1/5/2020	21
3/1/2020	56


Average	40.33333333

Re: Find Average Days Between multiple deliveries

fmvizcaino — Wed, 22 Apr 2020 17:19:57 GMT

Hi @BretPinkerton ,

I'm sharing an example where I use the multi-row tool to create the difference of days between the delivery dates.

Take a look and see if this is what you are looking for.

Best,

Fernando Vizcaino

Re: Find Average Days Between multiple deliveries

BretPinkerton — Wed, 22 Apr 2020 20:11:04 GMT

Thank you!!!!!