Estimating Remaining Days

You're right. I had forgotten which days you were needing. This should be correct. Please mark as solved if this is what you were wanting. Thanks!

All comments

Here is how I would do this. I made an assumption that you needed to forecast based on the other fields (i.e. y/n, sold/unsold) as well.

Hey, thanks for this. Wondering how I could still include 12/22, 12/23, and 12/24 in the output. Right now they are not included

Apologies, change the union input for #2 as shown here:

That makes more sense, thanks!
Were you getting an error on the "Generate Rows" tool? My workflow is saying 'The field "RowCount" is missing. Compare the tool configuration with the input stream.' ?

So essentially, I just moved the union to pull in your original data and add the new. The newly added are still summarized as joining would end up creating duplicates otherwise. I think this is what you're looking for, but let me know if it isn't.

Hi Bolide,

So the output looks good in terms of just adding to the existing raw data, except the data that is added is only 4 rows. Could you help me make it so that the entire target day is added? For example, 29th uses the 22nd as its 7 day look back estimation day. In this case we would see 137 rows of the exact same data from the 22nd used for the 29th.

For the 30th, we will see 126 rows with the date 23rd be used for the 30th.

Does this make sense?

I guess there is a reason that you are trying to duplicate all of the transactions individually. For forecasting, I would typically not need them. See the "New Method" container for the solution.

First of all, thanks for your effort here. This output for the "New Method" doesn't include the 29th, 30th, 31st. The output should not have any forecasted dates outside the month.

You're right. I had forgotten which days you were needing. This should be correct. Please mark as solved if this is what you were wanting. Thanks!