I am looking to aggregate the timeseries data of energy consumption which has been recorded for every minute into a daily or weekly average and work on it, as this dataset has humongous rows, i need it to be minimized to days or weekly.
looking forward to hear for guidance.
Solved! Go to Solution.
you can first use Date to Numerical to get the #weeks since 1970 (or days). Afterwards you can use the usual aggregate .