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!