Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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 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
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |