Ignore Filter - Revision history

Mtabadmin at 16:28, 6 August 2013

2013-08-06T16:28:15Z

Mtabadmin at 22:14, 5 August 2013

2013-08-05T22:14:35Z

Mtabadmin at 17:28, 1 August 2013

2013-08-01T17:28:12Z

Mtabadmin at 17:29, 31 July 2013

2013-07-31T17:29:46Z

Mtabadmin at 17:28, 31 July 2013

2013-07-31T17:28:19Z

Mtabadmin at 16:45, 29 July 2013

2013-07-29T16:45:25Z

Mtabadmin at 17:46, 18 July 2013

2013-07-18T17:46:36Z

66.124.51.254: minor change

2013-07-01T23:46:20Z

minor change

Mtabadmin at 18:59, 28 June 2013

2013-06-28T18:59:06Z

Mtabadmin at 18:55, 28 June 2013

2013-06-28T18:55:14Z

@@ Line 18: / Line 18: @@
 In the next analysis, 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.
+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 Index to Column as the format for the first column question and Formatted Sample Total for the second column question.
-Once the tab has ran, 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.
+After the tab has ran, we then select the second question's Formatted Sample Total column as the index column. To set an index column, highlight the desired column and select '''Set Base Column''' from the '''Base Column''' icon on the toolbar. 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.

← Older revision		Revision as of 22:14, 5 August 2013
Line 1:		Line 1:

−	[[File:Filter ignore-filter ~~select-~~ignore-filter.jpg\|thumb\|right\|x350px]]	+	[[File:Filter ignore-filter ignore-filter.jpg\|thumb\|right\|x350px]]
	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.		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.

← Older revision		Revision as of 17:28, 1 August 2013
Line 1:		Line 1:
		+
		+	[[File:Filter ignore-filter select-ignore-filter.jpg\|thumb\|right\|x350px]]
	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.		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.


−	~~[[File:Filter ignore-filter select-ignore-filter.jpg\|thumb\|right\|x350px]]~~
	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.		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.

@@ Line 1: / Line 1: @@
 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.
 [[File:Filter ignore-filter select-ignore-filter.jpg|thumb|right|x350px]]
@@ Line 12: / Line 10: @@
 With one of the two column questions selected as shown, right click and select the Ignore Filter option from the right click menu. As seen in the image below, 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 has ran 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.

@@ Line 2: / Line 2: @@
-[[File:ignorefilterselection.jpg|thumb|right|x350px]]
+[[File:ignorefilterselection.jpg|thumb|center|x350px]]
 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.
@@ Line 12: / Line 14: @@
-[[File:ignorefilterhighlightcolumn.jpg|thumb|center|x350px]]
+[[File:ignorefilterhighlightcolumn.jpg|thumb|center|x350px]][[File:Filter ignore-filter spreadsheet-view.jpg|thumb|center|x350px]]
 When the tab has ran 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.

@@ Line 1: / Line 1: @@
-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.[[File:ignorefilterselection.jpg|thumb|right]]
+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.[[File:ignorefilterselection.jpg|thumb|right]]
 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.
+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]]

← Older revision		Revision as of 23:46, 1 July 2013
Line 1:		Line 1:
−	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.[[File:ignorefilterselection.jpg\|thumb\|right]]	+	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.[[File:ignorefilterselection.jpg\|thumb\|right]]

	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.		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.