A powerful new mTAB analysis feature, "Ignore Filter", is available on mTABWeb.
This feature allows users to compare FILTERED and UNFILTERED columns of data side by side within the same mTAB spreadsheet view.
What's more, by using mTAB's column index and "select base column" toolbar tool, mTAB can provide an analytical comparison between filtered and unfiltered
data within the same spreadsheet view.
Let's use a few simple examples to illustrate this new functionality. First off, you apply the new 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 below, 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 above, 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 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 below, 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 as 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, in this example, 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 was run, we then select the second question's Formatted Sample Total column and used 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.
