Page 1 of 1

SAMPLE filter not working?

Posted: Thu Jul 17, 2025 5:31 pm
by simonmoon
Hello,

I tried to create a random sample from the data opened. The SAMPLE function in the filter doesn't seem to be working. Here is the syntax I used.

SAMPLE(`Acc`, 50, 'test')

There are over 400 case in the data file and this filter excluded all the cases. I varied the parameters but nothing worked. Any clue?

Re: SAMPLE filter not working?

Posted: Thu Jul 17, 2025 11:55 pm
by jonathon
with filters, a value of 1 is a "tick", and anything else is a "cross".

so use this instead:

SAMPLE(1, 50)

jonathon