forecasting and using the forecast

[guilhem]

Hello,

My table is a list of issues. Those issues are can last from 1 to a few days. Some are predicted and some aren't.

My table is the list for each day (when there is a problem) of each issue with a planned/unplanned tag.

The table is as follow:

Issue number

Date 

Type (planned/unplanned)

Planned can be predicted therefore, there are issues with dates in the future. Unplanned aren't predictable, and therefore there aren't any dates in the futures for those. I would like to create futures issues myself. 

How could i do it automatically and have the result added to my table so I can actually forecast issues in the future ?

Hope this is clear 

Guilhem

[v-ljerr-msft]

Hi @guilhem,

Could you post some sample data and the expected result in your scenario?

Regards

[guilhem · Accepted solution]

yes sure ... here we are ... 

Issue#	Date of Issue	Type	Qty
1	01/01/2016	Planned	10
1	02/01/2016	Planned	10
1	03/01/2016	Planned	10
1	04/01/2016	Planned	10
2	03/01/2016	Unplanned	5
3	06/02/2016	Unplanned	3
3	07/06/2016	Unplanned	3
3	07/10/2016	Unplanned	3
3	06/02/2017	Unplanned	3
3	08/06/2017	Unplanned	3
4	10/03/2016	Planned	5
4	11/03/2016	Planned	5
4	12/03/2016	Planned	5
4	13/03/2016	Planned	5
4	14/03/2016	Planned	5
4	15/03/2016	Planned	5
4	16/03/2016	Planned	5
4	17/03/2016	Planned	5
4	18/03/2016	Planned	5
4	19/03/2016	Planned	5
4	20/03/2016	Planned	5
4	21/03/2016	Planned	5
4	22/03/2016	Planned	5
4	23/03/2016	Planned	5

I would like to be able to add unplanned events with future dates to this table based on past unplanned only issues

[v-ljerr-msft]

Hi @guilhem,

---

---

I would like to be able to add unplanned events with future dates to this table based on past unplanned only issues

What do you mean about "add unplanned events with future date based on past unplanned only issues"? Could you be more precisely with your expected result?   It is better to post your expected result within the sample table above.

Regards