Excluding multiple rows with one filter
Excluding multiple rows with one filter
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.
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.
Re: Excluding multiple rows with one filter
Hi Brenna,
Could you give an example of what you have tried? I don't seem to have any trouble filtering out multiple rows.
Could you give an example of what you have tried? I don't seem to have any trouble filtering out multiple rows.
Re: Excluding multiple rows with one filter
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
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
Re: Excluding multiple rows with one filter
Hi, Brenna.Brenna wrote: I am wanting to exclude the particpants who did not complete the survey, using the finished or progress column.
Maybe this suggestion might be useful?
Cheers.
Maurizio
- Attachments
-
- ScreenShot_FILTER2.png (54.51 KiB) Viewed 29013 times
Re: Excluding multiple rows with one filter
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
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
Re: Excluding multiple rows with one filter
Thank you Maurizio, I will try that. I really appreciate everyone's input
Re: Excluding multiple rows with one filter
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..
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..
Re: Excluding multiple rows with one filter
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
ROW()!=2 and ROW()!=5 and ROW()!=7
Re: Excluding multiple rows with one filter
Here's another example. It filters-out Row 2 ad Rows 5 through 7.
Code: Select all
not(ROW()==2) and not(ROW()>= 5 and ROW()<=7)