Time Series Prediction on Multiple records

[CorCor]

Newbie when it comes to forecasting.....

BUt surely - there is an easy answer to this.

If I have a table - and every record is a series - how can I forecast in masse?

I want to forecast 2026 for every record.

All the examples/videos I have found basically show how to forecast ONE number, how do i give a number for every row in the example?

[Garabujo7]

Hello @CorCor ,

You mean this:

You could use the TS Model Factory and the TS Forecast Factory to get forecast at several different aggregation levels.

Attached you'll find the workflow.

Hope this helps.

Gabriel

[CorCor]

I dont think so.  I think I messed up and failed to mention......the numbers in the CODE column (1st column) represent different counties.  These are employment numbers.  So I was trying o see if there was a quick way to project 2026 for each county and each business category.  Thanks though

[LiuZhang · Accepted solution]

workflowwarning

Modified @Garabujo7 workflow to your requirement of per country + category. Though some fields are lacking variation in the values.