I wish to sum "seats" that occured in the next 59 minutes for each "orig" and each dep datetime (date + dep time). This needs to be done without using a table calculation such as window_sum
I was thinking that it may need a LOD such as {fixed [orig] :
I have attached two workbooks, one with the data and one with the two calculations but done in excel
Shown is an image of what sort of output i want to achieve is.
For each year, i want to find the maximum "rolling hour seats" for each airport and the associated day that this occurred. The end goal is to obtain the "rolling hour seats ratio" for each airport. This is the "max rolling hour seats" / "sum of the seats in that day". What this tells us is what percentage of seats occurred in the busiest hour of the day.
The reason i don't want to do a table calculation, from my understanding, is that the data in the table needs to be at the level you wish to sum across. (eg. i will need to have the data listed at the minute level). I believe this means i will not be able to produce a table like this, but i may be wrong.
I have included the example calc workbook again but this time with this table in it.
In regards to your issue regarding no unique ID for each flight, i am interested not in each flights value per say, but each minutes value. If each of the 6 flights has the same rolling hour value, that is completely fine as they all occur at the same time, and therefore are part of the same rolling hour.
Thanks again
