There are three ways in which users can apply a filter in an analysis.

  1. Applying a filter on Collections: This gets applied to all the analysis that are created under a Collection. To refer, click here.
  2. Applying a filter on an Analysis: This applies on the table created in an analysis. To refer, click here.
  3. Applying a filter to an axis in a table: This applies to an axis in a table i.e. only one attribute.

In this article, we discuss about the third option i.e. how to apply a filter to an axis in a table. This is different when compared to the other two as the filter is only applied on one attribute and not the whole table. 

Let us show how this works with an example.

The question used for this example is a simple grid (refer screenshot below) and the analysis type is 'Distribution by Attribute'.

After creating 'Distribution by Attribute' (Click to refer) the below table is generated.

To apply a filter to an axis in a table, click on 'Properties' (highlighted in red).

Clicking will open the properties pop up showing the list of all the attributes (highlighted in red) where user can choose any one attribute and can apply the filter.

Suppose user chooses the attribute 'Veg. Singles'. Clicking on veg singles will highlight in blue and then user can click on filter. 

Clicking will open the logic builder. To know more about 'Logic Builder' please click Here.

The Logic Builder opens up with AND condition by default and options to add rule where you can specify your logic. Click on “+” sign to add row where you can specify your logic as shown above.

The added row will contain four fields which has specific contents as below:-

  • The First field of the row gives you two options: Survey , Sample data and System.

Choose survey if your logic is based on a question you created in your survey. Choose sample if your logic is based on the sample data and choose system if you want to choose a system generated question.

For the example that we are considering, choose the option as “Survey”

  • The Second Field displays questions. This is dependent on the first field. If you choose Survey in your first field, it will show all the questions that are used in the analysis you have created or the analysis shared.

  • The Third field gives you the “condition list” from which you can choose whatever condition you want to apply for your option display logic.

  • The Fourth field displays the question options you selected in the second field.

Click on Set to apply the filter. The entire fields combine together to create one logic based on which the results will be shown. 

After clicking on Set, user will be redirected to the properties pop up. Here you can validate that a filter has been applied to the attribute by the presence of the filter icon (highlighted in red). .

Clicking on Set will apply this filter and create the table. The filter is only applied to 'veg singles' showing veg singles rating for the people who have pizza 1-2 times a week.

If the collection or analysis filter had been used, then the filter results would have affected the numbers for all the attributes in this table but because we have applied a filter to an axis that's why the filter was just applied on veg singles (highlighted in red) and not all the attributes.