Ignore Filter
Let's use a few simple examples to illustrate this new functionality. First off, you apply the Ignore Filter function to one or more column questions in your selected tab. This implies that at the minimum, at least two column questions must be selected, along with a filter condition.
As shown in the example, a typical analysis may entail selection of the identical column question twice, allowing for the comparison of filtered vs. unfiltered views of the column banners in mTAB™'s spreadsheet view.
With one of the two column questions selected as shown, right click and select the Ignore Filter option from the right click menu. The selected column question will be highlighted as shown within the column question selection panel to denote that the ignore filter has been applied.When the tab is run the columns associated with this question will ignore the filter condition established in the filter question selection panel (not shown). From the example shown, note the highlighting on the columns that are "unfiltered" and note as well that the question text (i.e. row 1 in the spreadsheet view) is now prefixed with the "UNFILTERED" indicator.
In the next analysis (shown below), we change the filter and column questions to illustrate the benefit of using the ignore feature in conjunction with the column question format "Index to Base Column".
In this example we select a new column question twice and once again we remove the filter from the second column question. However, we have selected Question Responses and Index to Base Column as the format for the first column question and formatted the second column question to Formatted Sample Total.
Once the tab has run, we then select the second question's Formatted Sample Total column and use the spreadsheet view's base column toolbar button to choose the unfiltered sample total as the base for our percentage index. The filtered brand data for "Brand G" is now shown in comparison to the overall unfiltered sample total - an analysis that would require the comparison of two individual tab runs had we not incorporated the Ignore Filter feature.
