1 of 1 people found this helpful
This can be done by creating a calculated field for Status that essentially assigns a number to each (Red or Green). Similar to the following:
if Status='Red' then 1 else 0 end
Then, create a second calculation similar to the following:
if sum([Status Number]) = 1 and sum([Status Number]) =lookup(sum([Status Number]), -1) or sum([Status Number]) = 1 and sum([Status Number]) =lookup(sum([Status Number]), 1)then 1 end
You can then, filter out the null values and you have all your consecutive Red statuses.
Hope this helps!
that was helpful - and we already a similar calculation for counting ALL red status.
But I'm still struggling to keep only the last problematic sequence - in my example, for the Project A, I need only the last sequence.
If a project has 3 red results, then some green, then 4 red results again - how can I display only 4 (and not 7...)
Also - when I'm filtering, numbers are changing (I think) - is there a way to "fix" a value or to make a calculate field ignoring filters / grouping?