Hello
I thought to be pretty good at Set Analysis but recently I bumped in a weird case:
I need to analyse the temporal evolution of some data and ended up to use search strings in my set analysis.
Using this solution,
I have been faced with weird result that I have been able to reproduce in a simple use case:
Let's load those data:
LOAD * INLINE [
KEY, VALUE
A, 1
A, 2
B, 1
C, 2
C, 1
D,1
D,3
];
count({<VALUE={'1'}>}KEY) is equal to 4 ... not surprinsingly
BUT
count({<KEY={"=(VALUE=1)"}>}KEY) IS = 1 ????? It seems to count only Those Key whose only value is 1!?
Why?
And How can I get 4 using a search string?
