Relational Operator in filter not working as expected

[tschullo]

I have a simple data set of numbers:

LOAD * Inline [
MyNums
20250826093150
20250826093151
20250826093152
20250826093153
20250826093154
20250826093155
];

When I add a filter in the app for MyNums and do a search within the filter using the string
"<20250826093152" (without the quotes), I expect to get:

20250826093150 and 20250826093151. 

Instead I get nothing.

If I change my filter to "<20250826093153" I get 20250826093150.
If I use "<20250826093154", I get 20250826093150 and 20250826093151.

Does anyone know why this is happenning and how I can fix this? I would prefer a solution that the user can do in the filter search, but if it's the data, let me know.

[tschullo · Accepted solution]

this works: =only(MyNums)<20250826093152