Data summing based on date

[ayadav8]

Hi,

I have a year worth of historical shipment data grouped by shipment dates, origin, and destination city. I am trying to do a sensitivity analysis by combining weights between a common start and end city. Want to combine weights with n days of difference

* For example: combine today's and tomorrow's (1-day difference), or

* combine today and next three days

n days is a variable here. Is there an easy way to do this? 

Attaching the sample file. Thanks!

[kat]

Hi @ayadav8

Here's something to get you started

Cheers

Kat

[ayadav8]

@kat thanks for replying. I am not able to import the workflow since it's been made on a newer version of alteryx. I see you used DateTimeNow() to get the difference. I actually want to sum the weights using the "Ship Date" column.  Adding the weights wherever the day difference (between ship dates) is n. 

[ayadav8]

I still have the question open. Is there anything that can be done?

[ayadav8 · Accepted solution]

Nevermind, I think I got what I needed. I used the multi-row tool to get there.