Hello all,
I would like to ask you for help. I am currently facing very interesting challenge and unfortunately I can't solve it alone.
In this table you can see list of 5 products with error description.
Result should like this:
I need to find out how many times we got "no error" without interruption in row in last occurrence of an particular product.
If we have have as last record "error" then counter should be reset.
Actual result I am looking for:
Thank you very much for any help you may provide, because I can't move forward at all.
I would like to ask you for help. I am currently facing very interesting challenge and unfortunately I can't solve it alone.
In this table you can see list of 5 products with error description.
Product | Error description |
1 | error0 |
1 | no error |
2 | error1 |
2 | erroe4 |
3 | no error |
4 | error2 |
5 | error2 |
4 | no error |
4 | no error |
5 | no error |
5 | no error |
5 | no error |
1 | error5 |
5 | no error |
1 | no error |
4 | error2 |
4 | no error |
1 | no error |
3 | no error |
3 | no error |
5 | error4 |
1 | no error |
4 | no error |
1 | no error |
3 | no error |
4 | error6 |
5 | no error |
5 | no error |
Result should like this:
I need to find out how many times we got "no error" without interruption in row in last occurrence of an particular product.
If we have have as last record "error" then counter should be reset.
Actual result I am looking for:
1 | no error | 4x |
2 | no error | 0x |
3 | no error | 4x |
4 | no error | 0x |
5 | no error | 2x |
Thank you very much for any help you may provide, because I can't move forward at all.