Rolling average (30 days) using continuous time data
I have 180 days of recent data totaling 2574 rows in JMP. I have included a file with just two columns, one is the DATETIME stamp and the other is the MAX_VALUE data at that timestamp. I have created an X-Y chart of MAX_VALUE (Y-Axis) vs DATETIME (X-Axis). I wish to add a trendline where its value at any given time is equal to the average value of MAX_VALUE over the past 30 days. Can somebody help...