Time Travel or How to move a field through time for prediction purposes

| inputlookup app_usage.csv | reverse | streamstats window=1 current=f first(RemoteAccess) as RemoteAccessFromFuture | reverse | ...

purpose:

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.

requirements:

comments:

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