Forum Discussion
Solved
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...
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,
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