I am trying to show a 3-day average of historical data, that reflects the average at the current time. So, for example, I would want to display the 3 day average of the data at 8:30 am, and then at 8:31 am for it to update to reflect the 3 day average at that time. Does anyone have any ideas how represent this using a formula?