Forum Discussion
forecasting and using the forecast
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
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
3 Replies
Hi guilhem,
Could you post some sample data and the expected result in your scenario?:smileyhappy:
Regards
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
Hi guilhem,
I would like to be able to add unplanned events with future dates to this table based on past unplanned only issuesWhat 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? :smileyhappy: It is better to post your expected result within the sample table above.
Regards
