Time Series forecast on multiple labels see sample data
Contributor IIHi,
I would like to forecast the attached data for future months for each client name. How can I do this? I'm comfortable to forecast for single client but how can we achieve for all clients in a single process. Please see attached sample data format.
Thx for your guidance
Tagged:
0
Answers
Hi @sunnyal,
If you want to use a model per customer, you have to build one process per customer (in your case 5).
You can also use Loop Attributes to forecast the evolution of all your customers. In this case, you can only use the same model for all your attributes (your customers). In your case, I think kNN model is the good choice.
But I have diificulties to recover the timestamp after performing the forecasting and the "merging" of your different attributes.
Anyways, you can find the process here :
You have to install the "Series Extension" extension (from the marketplace) to have the Predict Series operator.
I hope it helps,
Regards,
Lionel
You can use the LoopValues operator and store the result in a macro to build a model for each customer.
This is a rough example of this, in a real case you would be doing a lot more preprocessing and sometimes storing results to disk for later processing.
@JEdward @lionelderkrikor Thank you for the response.
@JEdward How do you define a label here, on which attribute?? I tried your process and it complains about missing label??
@JEdwardOk I got the model working, when I set role and define a label. However, the store oprator stores the model output for each client, so now how do I forecast this for all clients at once for future dates (i.e.) till December.
Is there a operator to join all the model outpus ??