| inputlookup app_usage.csv | reverse | streamstats window=1 current=f first(RemoteAccess) as RemoteAccessFromFuture | reverse | ...
Align a future value with the features in the past based on some time delta (Time to Decision, Time to Action) for machine learning or predictive analytics in general.
Props to Tom LaGatta
Be careful , check
1) for current=f
2) if your time frame is correct for the |reverse bit.
3) if you are confused about first() verse last(), use a line chart and check