Outil Table

Use Table to create a data or pivot table to output in a report via the Render tool.

Table Mode and Group By Selection

• Table Mode: Select a type of table. Options are:
  • Basic
  • Pivot (Cross Tab): Use the Pivot mode when you use data from a Cross Tab tool.
• Group By: Select the fields to group by. A separate table is created for each group of records.

Table Configuration

• Table Width: Select the width of the table.
  • Automatic: Sets the minimum width for the data contained within a table to display.
  • Percentage: Sets the percentage of the page for the table to be displayed, where 100% is the entire width of the page.
  • Fixed: Sets the width of the table in inches.
• Pivot Style (use with Cross Tab tool): Select the style for displaying the data in the table. This option is only available when you use data from a Cross Tab tool. Refer to the Data Examples section below to learn more. Compare the beginning data example to the example output for each Pivot Style option.
• Bar Graph (use with Basic table mode): Specify the data field for which to create a bar graph in the table. This option is only available for a basic table. Select Settings to modify the style of the bar graph.
• Show Column Headings: Displays column headings in the table. This option cannot be deselected for a pivot table.

Per Column/Methodology Configuration

• Per Column/Methodology Configuration: If the table mode is Basic, configure the columns and if the table mode is Pivot, configure the methodologies.
  • Select the data fields to include in the table.
  • Select a data field and use the up and down arrows to change the order in which the data displays in the table.
  • Select a data field to configure these attributes:
    • Rename Field: Enter a new name for the data field.
    • Width: Select Automatic, Percentage, or Fixed for the width of the data within a column.
    • Alignment (H): Select the horizontal alignment of left, center, or right.
    • Borders: Select to have borders on the left or right sides, or both sides, or to not have any borders.
    • Prefix: Enter text to add before the data.
    • Suffix: Enter text to add after the data.
    • Dec. Places: Select the number of decimal places to include.
    • Column Rules: Create or edit a rule to apply to a column of data. For style options, visit Table Style Rules.

Table Style Settings

• Default Table Settings: Modify style options for the table. For style options, go to Table Settings Style Editor
• Create/Edit Row Rule: Create or edit a rule to apply to a column of data. For style options, visit Table Style Rules.

Table Tool in Apps and Macros

Because this tool includes an expression editor, an additional input anchor displays when you use the tool in an app or macro workflow. Use the Interface tools to connect to a Question anchor.

Pivot (Cross Tab) Data Examples

Compare the Beginning Data Example to the example outputs in the tabs that follow.

Beginning Data Example

LocaleDesc	Avg_Regular	XRow_Regular	XCol_Regular	Count_Regular	Avg_Special_Ed	XRow_Special_Ed	XCol_Special_Ed	Count_Special_Ed	Avg_Voc_Tech_Other	XRow_Voc_Tech_Other	XCol_Voc_Tech_Other	Count_Voc_Tech_Other	Total
Central City	57	97	15	1	0	0	0	0	2	3	8	1	59
Rural	182	97	49	1	0	0	0	0	6	3	23	1	188
Town	116	87	31	1	1	1	50	1	16	12	62	1	133
Unknown	5	63	1	1	1	13	50	1	2	25	8	1	8
Urban Fringe	9	100	2	1	0	0	0	0	0	0	0	0	9
Total	74	93	100	5	1	1	100	2	7	7	100	4	397

Methodology over Variable

Methodology over Variable: The method for aggregating the data displays above the selected data field.

		Avg			XRow			XCol
LocaleDesc	TotCol	Regular	Special Ed	Voc/Tech/Other	Regular	Special Ed	Voc/Tech/Other	Regular	Special Ed	Voc/Tech/Other	Regular	Special Ed	Voc/Tech/Other
Central City	59	57	0	2	97	0	3	15	0	8	1	0	1
Rural	188	182	0	6	97	0	3	49	0	23	1	0	1
Town	133	116	1	16	87	1	12	31	50	62	1	1	1
Unknown	8	5	1	2	63	13	25	1	50	8	1	1	1
Urban Fringe	9	9	0	0	100	0	0	2	0	0	1	0	0
Total	397	74	1	7	93	1	7	100	100	100	5	2	4

Variable over Methodology

Variable over Methodology: The selected data field displays above the method for aggregating the data.

		Regular			Special Ed			Voc/Tech/Other
LocaleDesc	TotCol	Avg	XRow	XCol	Count	Avg	XRow	XCol	Count	Avg	XRow	XCol	Count
Central City	59	57	97	15	1	0	0	0	0	2	3	8	1
Rural	188	182	97	49	1	0	0	0	0	6	3	23	1
Town	133	116	87	31	1	1	1	50	1	16	12	62	1
Unknown	8	5	63	1	1	1	13	50	1	2	25	8	1
Urban Fringe	9	9	100	2	1	0	0	0	0	0	0	0	0
Total	397	74	93	100	5	1	1	100	2	7	7	100	4

Pivot Methodology to the Left

Pivot Methodology to the Left: The method for aggregating the data displays on the left side for each row of data in the table.

LocaleDesc	TotCol				Regular			Special Ed			Voc/Tech/Other
Central City	59	Avg	57	0	2	Central City	59	Avg	57	0	2	Central City	59
		XRow	97	0	3			XRow	97	0	3
		XCol	15	0	8			XCol	15	0	8
		Count	1	0	1			Count	1	0	1
Rural	188	Avg	182	0	6	Rural	188	Avg	182	0	6	Rural	188
		XRow	97	0	3			XRow	97	0	3
		XCol	49	0	23			XCol	49	0	23

Pivot Variable to the Left

Pivot Variable to the Left: The data displays in the table on the left side of the method for aggregating the data.

LocaleDesc	TotCol				Avg			XRow			XCol
Central City	59	Regular	57	97	15	1	Central City	59	Regular	57	97	15	1
		Special Ed	0	0	0	0			Special Ed	0	0	0	0
		Voc/Tech/Other	2	3	8	1			Voc/Tech/Other	2	3	8	1
Rural	188	Regular	182	97	49	1	Rural	188	Regular	182	97	49	1
		Special Ed	0	0	0	0			Special Ed	0	0	0	0
		Voc/Tech/Other	6	3	23	1			Voc/Tech/Other	6	3	23	1
Town	133	Regular	116	87	31	1	Town	133	Regular	116	87	31	1