Skip to main content

FV Decipher Support

All the topics, resources needed for FV Decipher.

FocusVision Knowledge Base

Editing Tables in Crosstabs

Overview

By default, Crosstabs includes a report table for each survey question. Both the size and content of each table depends on the overall complexity of the associated survey question, but users do have the option to change the way the data is displayed in the report and exports. This article will guide you through the table editing functions available within Crosstabs.

 

1: Accessing the Table Editor

Question tables can be configured using the Table Editor in Crosstabs. To edit the table for a survey question, click the table icon at the top right of that question in the report:

tables_001.png

The Table Editor will appear, where you can start making changes. Tables contain the following configuration options:

tables_002.png

1. Question label: This is the system label for the question; it can be used to find the question in the report.

2. Edit the question text: Enter alternative text for the report (the respondent view is not changed).

3. View Question: View a preview of the question as it is/will be shown in the survey.

4. Nest Rows under Nets: Check this box to show or hide options in nested rows.

5. + Table Row: Create and add nets or statistical summaries to the table. Availability of nets and stat options will depend on the question type.

Any nets predefined in the survey.xml and standards.xml files will automatically be included in the table.

6. Show/Hide answer options: Hide any answer option by unchecking the box.

  • You can hide a row, but still keep it included in the total base by checking the "Include in Base" box for a hidden row.
  • If hiding a row that's included in a net, be sure to "Include in Base" so the percentages make sense.

7. Edit the answer option text: Enter alternative text for the answer option for the report (the respondent view is not changed).

8. Include in Base: Uncheck the box to exclude an answer option from the base count. The base is a numeric value represents the total number of respondents who saw or answered the question (depending on the option selected).

9. Stat Values: Edit the statistical value for any answer option.

10. Nets/Subnets: This is where nets and subnets will appear that you have created using the “+ Table Row” function (explained further below).

11. Edit Nets: Edit any nets and subnets already applied to the table.

12. Apply Custom Filter: Check this box and select a saved segment or date range to apply a custom filter to the question. This only applies the selected filter to the selected question.

Applying the "Total" segment will not change the data.

13. Save: Save the changes for the table.

Any changes made in the table editor are global and apply to all users in all Crosstabs reports. 

2: Adding/Editing Nets

2.1: Adding a Row Net

When creating nets, there are options available for selecting a type of net and the position of the net. To create a new net, first click the "+ Table Row" button in the Table Editor:

tables_003.png

Then select a row type, enter a title, and check the boxes for any rows you would like to use for the net:

tables_004.png

Row Types:

  • OR Net - Add the vertical frequency percentages and counts, when any of the included rows was selected in the survey.
  • AND Net - Add the vertical frequency percentages and counts, when all of the included rows were selected in the survey.
  • Mean - The average of all measured values for the included rows.
  • Median -  The middle value for the included rows.
  • Standard Deviation (Stddev) -The measure of variability or dispersion around the mean for the included rows.
  • Standard Error (Se) - Represents the confidence of the Standard Deviation for the included rows.
  • Sum - The total based on the sum of the included rows.
  • Count - The number of checkboxes from the included rows that were checked
  • Minimum (min) - The minimum value given for the included rows.
  • Maximum (max) - The maximum value given for the included rows.
  • Add multiple Statistics - Will open an additional option to add multiple stat rows with the same row inclusions

Finally, select where you would like your net to appear using the "Position" drop-down menu and click "Save":

tables_005.png

Position Options:

  • Above first included row - Displays the net before the first included row
  • Below last included row - Displays the net after the first included row
  • Above [row] - Displays the net before the selected option
  • Below [row] - Displays the net after the selected option

2.2: Adding Multiple Row Nets

You can add multiple stats to your nets by selecting “Add Multiple Statistics” in the Row Type drop-down menu:

tables_006.png

Regardless of the method you have used, once you have finished adding all of your nets, these will appear in your question table similarly to the below:

tables_007.png

2.3: Adding Subnets

It is also possible to create subnets for any row net by nesting nets you have already configured into new nets. To create a new AND/OR subnet, first click the "+ Table Row" button in the Table Editor:

tables_003.png

Subnets can only be created using the "AND"/"OR" row types. The system will not accept any statistical rows as subnets.

Then select a row type, enter a title, and check the boxes for any rows you would like to use for the parent net:

tables_009.png

Any row nets you have already configured will be displayed under "Nets to Include". Check the box for the nets you would like to use as subnets:

tables_010.png

Finally, select where you would like your net and subnets to appear using the "Position" drop-down menu and click "Save":

tables_011.png

Once saved, subnets will appear in the Table Editor with numbers in superscript, indicating the order in which they were created:

subnets_super.png

Subnet nesting is limited to four layers (i.e., you can add only three subnets to each row net).

2.3.1: Moving Row Nets

The Crosstabs table editor also has a drag and drop feature enabled, which allows you to quickly reorder any row in that table. Any row or table with the following icon  will allow it to be dragged and dropped:

tables_012.png

Nets will inherit the order of the rows that are selected, even when you move the rows or nets around.

2.4: In the Report

2.4.1: Viewing Row Nets

When you add a net to the question, a net summary row is added to each selected table in Crosstabs. Nets are collapsed by default and can be expanded to show all the included table rows and subnets using the arrow to the left.

For example, the "Frequently" net row below is added to each table aggregating the respondent selections of  "Once a day" or more often:

tables_008.png

Similarly, the subnets "Weekly" and "Daily" below are added to each table aggregating respondent selections of "Once a week" and "Once a day", respectively:

tables_008a.png

Subnets will always be shown above the rows included in the parent net.

3: Question Type Considerations

3.1: Multi-Dimensional Questions

The process for adding nets to multi-dimensional questions is the same, but the configuration option set for a multi-dimensional question has two sections. The following information is based on the below multi-dimensional question example:

tables_013.png

The left section of the Table Editor displays a list of tables you can view in crosstabs. The table list depends on the grouping of the question. The example question was grouped by rows and as a result, there is a table listed for each row that you can view in Crosstabs.

The right section displays the question columns. If the question had been grouped by columns, then the opposite would display for the left and right sections:

tables_014.png

3.1.1: Setting an Alternative Dimension

Changing the primary dimension of a question will change how your data is grouped:

tables_015.png

If showing a table for each Question Column is selected, this will display a table for each column choice in that question. If showing a table for each Question Row is selected, this will display a table for each row in that question.

By default, the primary dimension is based on survey setup (using question grouping or the adim attribute). Rotating from data grouped by column or row will also recalculate the data in each table and only be applied once it is saved.

3.1.2: Adding/Editing Summary Tables

You can take your multi-dimensional questions one step further by adding summary tables. Summary tables are distinct from nets, in that they will provide a statistical summary of ALL tables within each question. Both regular report tables and summary tables include drag-and-drop functionality, as well as custom grid table settings and table nets.

Here is a quick guide of what summary tables are available for each question type:

 

Multi-Select

(Checkbox)

Single-Select

(Radio / Dropdown)

OR Net

Yes

Yes

AND Net

Yes

No

Mean

No

Yes

Median

No

Yes

Std Dev

No

Yes

Std Error

No

Yes

Sum

No

Yes

Count

Yes

No

Minimum

No

Yes

Maximum

No

Yes

By default, all individual tables for multi-dimensional questions will be toggled off and only the grid table will be shown within Crosstabs. Manually turning all grid tables on/off via the “View Options” menu will only affect default grid tables. Any custom grid tables will remain as is. Click here for more information on the Crosstabs “View Options” menu.

Adding a Summary Table

To add a summary table, first click on “+ Table Row” at the top right of the table rows section:

tables_017.png

Then select the summary table you would like to include for your net:

tables_016.png

The *(value) is shown in tooltip logic when hovering over a stat net type. Also, when setting the specifications for your table rows, keep in mind that the following definitions apply to each option:

  • Grid Tables - A table that combines the scale and attributes for 2-dimensional question types. Uses the segments as filters instead of a banner.
  • Net Table - Creates a new table (or column in a grid table) that combines attributes from a 2-dimensional style question.

Once enabled in the Table Editor, the net summary tables will appear in grid format in the question table, similar to the example below:

tables_018.png

All table segments are automatically assigned a stat testing letter (starting with "A" and incrementing). The stat testing letters are used for comparisons between the different segments within the grid table.

Click here to learn more about stat testing within Crosstabs.

3.2: Numerical Questions

When you click "+ Table Row" for a numerical question, a new row displays for you to specify the details of the net. Specify a "Row Title" and "Net Values" to include in the net.  Then click "Save."

For example, if you enter "Young Adult" and a "Net Value" of 18-25 for an age question, the resulting net row displays "Young Adult" and then aggregates respondents who entered 18-25 for their age:

tables_0189.png

For the net value you can also use the form, value+. For example, if you specify a "Row Title" of "Senior" and "Net values" of 65+, the resulting net row displays "Senior" and aggregates respondents who entered an age of 65 and older.

Nets for numerical questions will appear similarly to the below within the question table once applied:

tables_20.png

Entering an invalid range displays all respondents. Also, be sure to specify a numeric "Net Value." Otherwise, you may be locked out of the table editor for that question and have to contact the help desk.