TS Forecast Model

[M-Harbi]

Hello

I am trying to build a forecast model that can predict future hardware demands for each business organization and each asset type combination.

I have three years data and the number of demands per org, per asset, per year, and I am trying to build a forecast model based on that info.

The results I am getting assume that each of those combination is a different year, which is wrong, I only have three years and many org/asset combination and I am trying to make the model to build a standalone prediction for each of those combos I have.

I am using TS Model Factory. Below is a small sample of the combos.

Any idea if I am using the right tool or how to build the iteration for each combo?

Org ID	Asset ID	Year	Sum_Transaction
1	5	2022	1460
1	5	2023	645
1	11	2023	282
1	11	2024	250
2	10	2024	1
2	11	2022	17
2	11	2023	93
2	11	2024	39
7	5	2022	2904
7	5	2023	3783

[M-Harbi]

It is working now!

Here is what I did:

1- I broke down the data into months like explained.

2- I added TS Forecast Factory node after the TS Model Factory, which what I was missing to iterate the forecast based on the desired periods. The data must be grouped and sorted first by the date column before the org-asset group.

Many thanks Alex for your great help and guidance, really appreciate it!