31 January 2017 |
5 Ways to Create a Filter in Displayr
This blog shows how to create a filter. Before reading this blog, make sure you check out Using Displayr to filter data, analyses, and whole reports, which describes what filters can do in Displayr.
1. Creating simple filters from the ribbon
The simplest way to create a filter is to select Home > Data Selection > New Filter (see below) and choose the variable or pair of variables that you wish to create a filter. If you are already on the Insert tab, you can save a mouse click by going straight to Insert > Variables > Filter.
When you create a filter by pressing the buttons in the ribbon, you are both creating a filter and applying the filter to any currently selected outputs or pages. All the other methods described in this post create, but do not apply, filters.
2. Tagging a variable as a Filter
Any non-text variable set in Displayr can be set as a filter. First select the variable in Data (bottom-left of the screen), and then choose Usable as a filter from Properties (right-middle of the screen). Cases that have a value of more than 0 are included in the filter.
3. Quickly creating lots of filters
To create lots of filters:
- Select the variable sets you wish to use to create the filters from Data (bottom-left of the screen).
- Insert > More > Utilities (far-right of the Insert tab in the ribbon).
- Filtering > Create Filters from Selected Variables.
5. Question Type
This is a more exotic approach than the others, but can be a huge time saver. When the structure of a variable set is changed to either Binary – Multi or Binary – Grid the values of the variables are automatically recoded to be 0s and 1s, and you choose which values are converted to 1s and which to 0s. Then, select Use as a filter for the variables.
Author: Tim Bock
Tim Bock is the founder of Displayr. Tim is a data scientist, who has consulted, published academic papers, and won awards, for problems/techniques as diverse as neural networks, mixture models, data fusion, market segmentation, IPO pricing, small sample research, and data visualization. He has conducted data science projects for numerous companies, including Pfizer, Coca Cola, ACNielsen, KFC, Weight Watchers, Unilever, and Nestle. He is also the founder of Q www.qresearchsoftware.com, a data science product designed for survey research, which is used by all the world’s seven largest market research consultancies. He studied econometrics, maths, and marketing, and has a University Medal and PhD from the University of New South Wales (Australia’s leading research university), where he was an adjunct member of staff for 15 years.