[[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]]