Hi there @AbbTheresa,
check here options how to simulate lag column with negative value in order to avoid using Sorter node twice (on the larger data set it can take a while): Lag Column with Negative value?
To deal with missing values I would recommend Rule Engine node. Fast and simple to use 
Br,
Ivan