Hello community,
I want to form a descending 'New_target' where 0 represents the failure of a machine (In Fault or Target). I show a table (the real data I will put it in excel to download). Any ideas?
Target | Date | Hours | Fault | S1 | New_target |
0 | 20/01/2018 | 8 | 0 | 6 | 0 |
1 | 20/01/2018 | 12 | 2 | 5 | |
2 | 20/01/2018 | 13 | 7 | 4 | |
3 | 20/01/2018 | 16 | 9 | 3 | |
4 | 20/01/2018 | 18 | 3 | 2 | |
5 | 20/01/2018 | 19 | 9 | 1 | |
0 | 20/01/2018 | 22 | 0 | 5 | 0 |
1 | 20/01/2018 | 23 | 3 | 3 | |
2 | 21/01/2018 | 0 | 8 | 2 | |
3 | 21/01/2018 | 1 | 7 | 1 | |
0 | 21/01/2018 | 12 | 0 | 7 | 0 |
1 | 21/01/2018 | 21 | 5 | 4 | |
2 | 22/01/2018 | 1 | 2 | 3 | |
3 | 22/01/2018 | 2 | 1 | 2 | |
4 | 22/01/2018 | 23 | 2 | 1 | |
0 | 22/01/2018 | 24 | 0 | 1 | 0 |
Solved! Go to Solution.
Hello @Danielht, would something like the attached solution work for you? Below are the broad steps I took:
Let us know if I misunderstood your ask, or if you need clarification on any specifics I used.
Hi @AbhilashR
Thank you very much for responding, but I would like Date and Hours to be ordered in ascending order. Only New_Target should be in descending form.
Can be done?
Hi @Danielht, thanks for getting back to me! I have modified solution to keep all columns as-is, but just reverse the number of target column.
Let us know if this works.
Thank you very much friend @AbhilashR , greetings from Lima Peru.