Expression in coloring the points into a line graph

[aaarox]

Hi community,

i need help in creating an expression to use for coloring groups of values with different colors  in a line graph.

In this graph, I represent a variabile that should be between two limits.

I would like to evidence (by coloring in red the points) all those points outside the limits for AT LEAST 5 CONSECUTIVE TIMES.

In this way I can avoid to highlights all those points that can be considered as outliers.

I'm trying to use a combination of RangeSum and Above but I don't find the correct formula.

I hope someone could help me.

Thanks,

Andrea

[Aasir]

Use below.
Replace YourVariable, LowerLimit, and UpperLimit with the actual field names and limit values from your data.

if(
RangeSum(
Above(
if(
YourVariable < LowerLimit or YourVariable > UpperLimit,
1,
0
),
0, RowNo()
)
) >= 5
or
RangeSum(
Above(
if(
YourVariable < LowerLimit or YourVariable > UpperLimit,
1,
0
),
0, RowNo()
)
) = 0,
Red(),
Black()
)