I’m building sales forecasts for this next year, forecasting daily revenue broken down by day periods (morning, day, night). I’m using the lag node to create several lags that I average together (-7, -14, -21, -28, -364) under a math formula node. The issue I can use help with is some past dates are holidays which means the sales were either $0 (closed for the day) or they are much higher than average with the holiday - it’s a restaurant.
How can I modify the math formula or a rule engine node approach to ignore a 0 amount entry in the averaging and/or compensate for an entry above-average? The other approach I’m considering is to manually edit individuals row entries, but I’d like to run this process routinely to update the forecasting accuracy with new actuals.
If data is needed I’m happy to attach some example, but thought I’d try to explain the concept first.
I figured out the logic within the math formula using if and average rules.
I know the forecasting/modeling can be improved beyond this simple averaging approach and I have distributed the data by time of day. Starting simple to get something in production then will consider posting sample data for suggestions on best ways to improve the process with modeling. Thank you ipazin for your input!