Forum Discussion
Count more than 3 consecutive values
Hi! Hope you can help me, this is what I am looking for: I have a column called Result, and what I would like to have is a measure that count more than 3 positive consecutive values per produ...
It is missed the top titles:
Week,Date,Product,Result,ConsecutiveTrue
The column Result has to have 3 consecutive positive values to be counted as 1. Or if you would like to see it in other way, the column ConsecutiveTrue must have 3 consecutive True to be counted as 1.