Why does separating terms by commas in a set analysis doesn't respect ranges?

[julioarriaga]

This set analysis:

=COUNT({<FechaEval={">=20180802"},FechaEval={"<=20180803"}>}Medicion)"

gives me 3 as a result but it should give me 2 according to my understanding. What I'm getting wrong?

Thanks in advance

P.S. Table I loaded:

T:
LOAD * INLINE [FechaEval,Medicion
20180801,1
20180802,1
20180803,1
20180804,1
20180805,1];

[petter · Accepted solution]

You can't repeat the same field - it will only make the last one go into effect. For your specific case you should write:

=Count( {<FechaEval={">=20180802<=20180303"}>} Medicion )