Pular para o conteúdo principal

FV Decipher Support

Todos os tópicos, recursos necessários para FV Decipher.

Base de Conhecimento da FocusVision

Editing Tables

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 there are a few things all Crosstabs tables have in common. This article will guide you through our table editing functions within Crosstabs.

 

1: Editing a Table

Each table generated can be hidden if desired by deselecting the table configuration button.

To edit a table, click on the table icon:

Most tables contain the following configuration options:

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

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

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

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

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

8. + Table Row: Create additional report rows, nets using /OR logic, or add a predefined net to your table.

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

10. Edit Nets: Edit any nets already applied to the table.

11. 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. (Tip:  Applying the "Total" segment will not change the data.)

12. Save: Save the changes for the table.

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

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 AND/OR net, click on the "+ Table Row" button in the Table Editor, and select a row type, title, position, and the logic you would like to use for the net:

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
     

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

2.2: Adding Multiple Row Nets

You can also add multiple stats at once by selecting “Add Multiple Statistics” in the Row Type drop-down menu:

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:

2.3: 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 table rows included using the arrow to the left - for example, the "Frequently" net row below is added to each table aggregating the respondent selections of  "9-10 times" and "11 or more times":



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:

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:

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:



3.1.1: Setting an Alternative Dimension

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

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 / Select)

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 summary tables, first click on “+ Table Row” at the top right of the table rows section:

Then check the "Add Summary Table(s) box to include summary tables for your nets:

The "Summary Tables" options match the statistical rows available for each table.

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:

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:

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:

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.