User Tools

Site Tools


help:filtering_data

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

help:filtering_data [2012/08/12 18:23] (current)
Line 1: Line 1:
 +[[http://​www.sofastatistics.com/​userguide.php | Contents]]
  
 +====== Filtering Data ======
 +
 +Sometimes you want to conduct analyses on a subset of your data e.g. on males only.  In SOFA you can apply temporary filters to your data.
 +
 +{{help:​tip.gif }} Remember: Filters will remain in place \\ until you close SOFA or deliberately remove them.\\ \\ \\ \\ 
 +
 +
 +
 +  - Select the table you want to filter
 +  - Click on the "​Filter"​ button (or right click on the table) and enter details into the Apply Filter dialog.\\ {{:​help:​filter_dlg.jpg|}}
 +  - Once you have applied you filter, the table name will appear with "​(filtered)"​ at the end until the filter is removed (or SOFA is closed).\\ {{:​help:​table_name_filtered.jpg|}}
 +  - Output will show the filter which has been applied\\ {{:​help:​filtered_output.jpg|}}
 +  * You can also modify your filter and apply much more flexible constraints\\ {{:​help:​flexible_filtering.jpg|}}
 +  * And if your filter is faulty, helpful examples are provided which are appropriate to the type of database you are connecting to (SQLite, MySQL etc).\\ {{:​help:​filtering_help.jpg|}}
 +
 +
 +[[http://​www.sofastatistics.com/​videos.php#​filtering |{{:​help:​play_button.gif|}}]] A video is available showing how to filter your data: [[http://​www.sofastatistics.com/​videos.php#​filtering | Filtering data video]]
 +
 +[[https://​www.youtube.com/​watch?​v=_rcgNW-Zcxo&​list=UUFRr0ugWcqCfhLwJ5qBlzpQ |{{:​help:​play_button.gif|}}]] Another video is also available showing a practical scenario where data filtering might be useful: [[https://​www.youtube.com/​watch?​v=_rcgNW-Zcxo&​list=UUFRr0ugWcqCfhLwJ5qBlzpQ]]
 +
 +[[http://​www.sofastatistics.com/​userguide.php | Contents]]
 +
 +[[:home | Wiki]]
help/filtering_data.txt ยท Last modified: 2012/08/12 18:23 (external edit)