About: This article introduces the Cross Tab node, an Output node within Construct.
Location: Node panel
Table of Contents
Feature Overview
The Cross Tab node creates summaries (counts, means, sums) across two or more categorical fields. This node generates summary data in a grid where the rows and columns represent groups combinations of data categories.
The user selects which variables will make up the CrossTab Rows and CrossTab Columns. Variables added to the CrossTab Columns must establish the unique values that exist within the variable(s) prior to running the node so that the number of records is known. This is done by clicking the ellipse button [...] under the Values section of a Cross Tab Column which will open the Get Unique Values utility. This is where the unique values that will organize and label the columns are defined. Identifying these values can be done automatically by clicking the Get Values button, by typing values in directly or a combination of both methods.
The CrossTab Values are populated using the checkboxes next to the available columns on the left side. CrossTab Values may also include Row and Column Sum and Percentage (%), or Cell Percentages (%) by checking the relevant boxes in the CrossTab Values section. The column headers that appear will consist of all the entries found in the Input node, regardless of whether this data had been removed at some stage. Use the report’s Remove Empty Column setup option to hide any unwanted columns.
Note:
- The Cross Tab node should be connected to Temp Report or a Report node to best view the results.
- Regardless of their original column types, all data emerging from this node are converted to type Text. Because of this, care should be taken when using the output of this node.
Video Tutorial
Related Article
Comments
0 comments
Article is closed for comments.