Forum Discussion
based on continuous values result
Hi All,
I have daily customer data in that if value continuously 7 then consider as 1 please find below example kindly help me.
| Date | Customer ID | Value |
| 01/10/2023 | 11100 | 7 |
| 02/10/2023 | 11100 | 7 |
| 03/10/2023 | 11100 | 7 |
| 04/10/2023 | 11100 | 7 |
| 05/10/2023 | 11100 | 7 |
| 08/10/2023 | 11100 | 7 |
| 09/10/2023 | 11100 | 0 |
| 10/10/2023 | 11100 | 0 |
| 11/10/2023 | 11100 | 0 |
| 12/10/2023 | 11100 | 0 |
| 15/10/2023 | 11100 | 0 |
| 16/10/2023 | 11100 | 0 |
| 17/10/2023 | 11100 | 0 |
| 18/10/2023 | 11100 | 0 |
| 19/10/2023 | 11100 | 7 |
| 23/10/2023 | 11100 | 7 |
| 24/10/2023 | 11100 | 7 |
| 25/10/2023 | 11100 | 7 |
| 26/10/2023 | 11100 | 7 |
| 29/10/2023 | 11100 | 0 |
| 30/10/2023 | 11100 | 0 |
| 31/10/2023 | 11100 | 0 |
| 01/10/2023 | 111002 | 7 |
| 02/10/2023 | 111002 | 7 |
| 17/10/2023 | 111002 | 7 |
| 18/10/2023 | 111002 | 7 |
| 19/10/2023 | 111002 | 0 |
| 23/10/2023 | 111002 | 0 |
| 24/10/2023 | 111002 | 7 |
| 25/10/2023 | 111002 | 0 |
now expected result like both customer values should be : (lets say first customer have continuous 7 values 2 times so result is 2 , and second customer have only one time continuous 7 value hence result will be 1.)
| Customer ID | Result |
| 11100 | 2 |
| 111002 | 1 |
5 Replies
the minimum not interruption is what should it be: 4 or 3 or 2?
pls try this
