Excluding multiple rows with one filter

General help and assistance with jamovi. Bug reports can be made at our issues page: https://github.com/jamovi/jamovi/issues . (If you're unsure feel free to discuss it here)

by Brenna » Tue Oct 08, 2019 7:46 am

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.
Brenna
 
Posts: 5
Joined: Mon Sep 16, 2019 8:39 am

by dropmann » Tue Oct 08, 2019 10:07 pm

Hi Brenna,

Could you give an example of what you have tried? I don't seem to have any trouble filtering out multiple rows.
dropmann
 
Posts: 60
Joined: Thu Feb 02, 2017 10:26 am

by MAgojam » Tue Oct 08, 2019 10:41 pm

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.
ScreenShot_FILTER.png
ScreenShot_FILTER.png (79.2 KiB) Viewed 57 times

Cheers.
Maurizio
User avatar
MAgojam
 
Posts: 62
Joined: Thu Jun 08, 2017 2:33 pm
Location: Parma (Italy)

by Brenna » Tue Oct 08, 2019 11:29 pm

2019-10-09.png
I am wanting to exclude the particpants who did not complete the survey, using the finished or progress column. Previously I have used ROW() != to exclude a single row.
I will try what you have done MAgojam thank you
2019-10-09.png (148.69 KiB) Viewed 55 times
Brenna
 
Posts: 5
Joined: Mon Sep 16, 2019 8:39 am

by MAgojam » Wed Oct 09, 2019 12:48 am

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
Attachments
ScreenShot_FILTER2.png
ScreenShot_FILTER2.png (54.51 KiB) Viewed 53 times
User avatar
MAgojam
 
Posts: 62
Joined: Thu Jun 08, 2017 2:33 pm
Location: Parma (Italy)

by jonathon » Wed Oct 09, 2019 4:28 am

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
User avatar
jonathon
 
Posts: 933
Joined: Fri Jan 27, 2017 10:04 am

by Brenna » Wed Oct 09, 2019 8:21 am

Thank you Maurizio, I will try that. I really appreciate everyone's input :slightly_smiling_face:
Brenna
 
Posts: 5
Joined: Mon Sep 16, 2019 8:39 am


Return to Help