jamovi

Im loving using Jamovi for my first year doing research. Its awesome!
Is it possible to exclude multiple rows using a single filter? I can exclude them one by one. Have tried a few other ways like using != or < or > but I cant figure it out.

Hi Brenna,

Could you give an example of what you have tried? I don't seem to have any trouble filtering out multiple rows.

Hi, Brenna.
Maybe I didn't understand your request, but as an example I enclose this screenshot where I applied a single filter, with multiple variables, to the iris data in the library. Cheers.
Maurizio

Brenna wrote: I am wanting to exclude the particpants who did not complete the survey, using the finished or progress column.

Hi, Brenna.
Maybe this suggestion might be useful?

Cheers.
Maurizio

hey,

i've just taken a look at this, and i'm a bit surprised it's not as straight-forward as i thought it would be.

looks like maurizio's suggestion is probably the best for the time being.

of you could use the formula:

1A != NA and 2A != NA and 3A != NA

NA is a special value signifying a 'missing value'. as a general rule, missing values, the way they're used in statistics, are confusing. i'll have a think about how we can make this more straight-forward.

cheers and thanks for bringing this up.

jonathon

Thank you Maurizio, I will try that. I really appreciate everyone's input

Is there a method to filter multiple rows by number with one filter?
e.g.
ROW()!=25 works fine, but if you want to filter out many rows, can you do this in one filter? (e.g. ROW()!=c(25, 35, 33, 53, 23) does not work..)

I only know that separate filters for every value work - cannot find shorter method..

To add to the examples provided earlier in this thread, the following filters-out Rows 2, 5, and 7:

ROW()!=2 and ROW()!=5 and ROW()!=7

Here's another example. It filters-out Row 2 ad Rows 5 through 7.