Difference between revisions of "Ignore Filter"
| Line 1: | Line 1: | ||
| − | A powerful analysis feature, "Ignore Filter", is available on mTAB™. This feature allows users to compare FILTERED and | + | A powerful analysis feature, "Ignore Filter", is available on mTAB™. 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 |
| − | 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 | "select base column" toolbar tool, mTAB™ can provide an analytical comparison between filtered and unfiltered data within the | ||
same spreadsheet view.[[File:ignorefilterselection.jpg|thumb|right]] | same spreadsheet view.[[File:ignorefilterselection.jpg|thumb|right]] | ||
| + | |||
Let's use a few simple examples to illustrate this new functionality. | 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. [[File:ignorefilterhighlightcolumn.jpg|thumb|left]] | ||
| + | |||
| + | |||
| + | |||
When the tab is run the columns associated with this question will ignore the filter condition established in the filter | 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 | 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. | 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 | 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". | 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. | 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 | 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. | 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 | Once the tab has run, we then select the second question's Formatted Sample Total column and use the spreadsheet view's base | ||
Revision as of 18:48, 27 June 2013
A powerful analysis feature, "Ignore Filter", is available on mTAB™. 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 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.
