To setup a Respondent Table the same logic for setting up other object boxes is used. The Respondent Table is found in the Start menu as shown in the image below.
To add content to the Respondent Table click Edit (on right click or in the object menu). The setup is done in four different tabs/steps:
- Variables – select variables to include in the table
- Filters – add filters to the table
- Settings – define time period, format of the table etc
- Layout – define color and size of text, background, grid lines etc.
In the first Tab the variables are selected. The desired variables are selected in the selection boxes as shown in the image below. In the top left corner (see the image below) a variable type filter is present to make it easier to find the variables: in the default view all variables are shown. In the bottom of the default list the Respondent ID and Respondent Date variables are shown as well.
You can select filters to apply to the Respondent Table. Selections can be done in several filter boxes at the same time and like in the chart setup – ‘AND’ is used between the boxes. So in the example below only old male respondents will be shown in the result table. The image below shows the Filter Tab in the setup of a Respondent Table.
The Settings Tab consist of several options which are described below.
- Time selections: Select the time period to show respondents from (Start and stop date) and the displayed format. The selected Time period will be shown above the Respondent Table as shown in the second image below if the “Display Time Period” option is checked. The selected Date format will be used above the table and in the Respondent Table itself if it contains the “Respondent date” variable. The image below shows the Time selection controls in the Settings Tab.
The image below shows a Respondent Table with a shown Time period above the table.
- Table settings – Layout
In the Table settings Layout section the disposition of the table is selected. In the section “Show variables in” – you define if variables should be shown in columns or in rows.
Note: The option “Rows, respondents in columns” is limited to 50 respondents. If you have more than 50 respondents they will not be shown. This is due to performance and this option should only be used in for instance Mystery shopping surveys where you show one column per wave. The image below shows the layout settings in the Settings Tab.
In the Table Width section you define the width of the columns. The default setting is “Fit in box” which means that the table will fill the whole object box and use its full size. If using the Minimum Column width option you define the minimum number of pixels of the columns. This means that the table can be much wider than the object box and in that case horizontal scroll-bars will appear inside the table.
In the general section, you can select the number of rows per page, show and hide question codes, hide questions without data and display the filter information. Besides this you have the ability to combine search boxes. Below you'll see the same table but with different search options. The table to the left uses a search per column while the table to the right has a general search that searches in all columns.
The Search field list contains the following four options
- One per column
- One for the complete table
- Both per column and the complete table.
Note: if the new search option is used in combination with the function that gives the Report users the ability to select which columns to be displayed/hidden you can define if the general search shall search in the hidden columns or not as shown in the image below.Here we see the setting for defining if the general search shall search in the hidden columns or not.
Within layout, different settings that control the layout can be adjusted:
- Respondent table layout: complete table adjustment
- General: adjustments for background color of the cells and Text (font, size, color, horizontal and vertical alignment, style) and cell padding
- Boarders: adjustments for cell borders (color, width, style)
- First row and first column: adjustments for style, background, text (font, size, color, horizontal and vertical alignment, style), borders and width/height.
- Scroll bars are not shown in the setup-mode. They are only shown in end-user mode. This is because it must be possible to move around the object box on the slide, if scroll-bars are present it usually scrolls instead of moving position.
- A column can never be less wide than the longest word in the column as row breaks never are done in the middle of a word. So a horizontal scroll bar can appear even when the option Fit in box is used.
- Dapresy supports a maximum of 50 columns