Rows, Columns and Edges panels (askiavista)

Rows, Columns and Edges panels (AskiaVista)

The rows, columns and edges panels in the table definition window determine which questions will appear in your charts and tables. At any time, you can freely re-arrange the questions in these panels (adding, removing and moving them), and thereby change the questions in your charts and tables.

Questions placed in the rows panel will appear on the vertical axis of your table, those in the columns panel will appear on the horizontal axis, and those in the edges panel will appear at the edges. For example, if you place a Gender question in the rows, and an Age question in the columns, the table or chart will display Age (across the top of the table) versus Gender.

Note that the Columns and Edges panels cannot be displayed at the same time: to switch between them, click columns or edges as appropriate.

You also use the rows, columns and edges panels to customise the format of your questions.

In this topic:

Placing questions into the rows, columns and edges panels

To place a question in the rows, columns or edges of your table, simply drag the question from the question list into the appropriate panel (note: in the rows and columns panels, you need to drop the question into the appropriate box, rows or columns). You can freely drag and drop questions between the rows, columns, and edges panels, until the questions are positioned as required.

If you only want to include certain responses, select the question, and from the distribution panel select the desired responses and drag them into the Rows panel; only these responses will be selected.

You can drag and drop an entire loop, or just the first question of the loop, by holding down CTRL as you drag. This saves time when you want to render a table at the interview level, as it avoids the need to change the table definition's level to the relevant loop, drag it, then re-switch the level. For more information, see the section on analysis level in AskiaVista.

You can freely drag and drop questions to move them between the rows, columns and edges panels.

Placing individual responses into the Rows, Columns and Edges panels

You can also add individual responses (or groups of them, by selecting multiple ones) into your table, by dragging them from the distribution panel at the bottom of the question tree: this creates a new question according to the response you dragged.

If you have selected at least one question, the shortcut CTRL + A (if you are using Windows) or CMD + A (if you are using Mac OS) selects all questions in the list.

Click the following icons to view and hide the responses for a question, respectively:

Show the responses;

Hide the responses.

Available commands

The following commands are available in the rows, columns and edges panels:

Command name	Description
Save question/s in profile	Allows you to save all the questions in the appropriate panel (rows, columns or edges) to a Profile. You can save them to an existing Profile, or a new one. When you select this command, the `Save dimension to profile` modal window appears. To save to an existing profile, select that profile in the list and click `Save`. To save to a new profile, in the `Name` input type a name for your new profile and click `Save`.
Move selection to...	Allows you to move the selected question or questions from the panel in question (rows, columns or edges) to another panel (rows, columns or edges). Simply select the destination panel (Rows, Columns or Edges) from the list that appears. You can select multiple questions by holding down `CTRL` while you click, or multiple adjacent questions by holding down `SHIFT` and clicking the first and last questions you want to select.
Move items up	Moves the selected item or items upwards in the list (and therefore upwards in the table). You can move entire questions, or responses within a question. You can select multiple items by holding down `CTRL` while you click, or multiple adjacent items by holding down `SHIFT` and clicking the first and last items you want to select.
Move items down	Moves the selected item or items downwards in the list (and therefore upwards in the table). You can move entire questions, or responses within a question. You can select multiple items by holding down `CTRL` while you click, or multiple adjacent items by holding down `SHIFT` and clicking the first and last items you want to select.
Rename the selected item	Allows you to rename the selected question or response, thereby changing how it appears in the table. Note that the original question or response name is not affected, only how this instance of it will appear in the table.
Select all This command is revealed if you click `More`:	If you have a question currently selected, this command selects all questions in the panel (Rows, Columns or Edges). If you have a response currently selected, this command selects all responses in the same question, allowing you to quickly activate a large number of response items. If you want to deactivate specific responses, click them while holding down `CTRL` (in Windows) or `CMD` (Mac OS). Note that instead of clicking this command, you can also use the keyboard short-cut `CTRL + A` (if you are using Windows) or `CMD + A` (if you are using Mac OS).
Unselect all This command is revealed if you click `More`:	If you have a question currently selected, this command un-selects all questions in the panel (Rows, Columns or Edges). If you have a response currently selected, this command unselects all responses in the selected question, allowing you to quickly de-activate a large number of response items.
Locate This command is revealed if you click `More`:	If you have a question or response currently selected in the rows, columns or edges panel, this command displays and selects that question in the question list in the left-hand pane. If the question is located inside a chapter, then the chapter (or chapters) are opened to allow the question to be displayed. This makes it easy to find questions within very large surveys.
Copy This command is revealed if you click `More`:	Copies the selected question to the clipboard, so you can paste the presentation or structure (see below) onto another question.
Paste presentation This command is revealed if you click `More`:	Paste the structure and formatting (bold, color, groupings, captions, etc.) of one question to another question.
Paste structure This command is revealed if you click `More`:	Paste the structure (that is, any grouped and calculated responses) from one question to another without overriding the captions of the responses.
Flatten This command is revealed if you click `More`:	Removes all grouped responses, both nested groups and un-nested. To remove just first-level grouped responses, see `Ungroup all`, below.
Add calculated response This command is revealed if you click `More`:	Adds an additional category to the selected question, calculated on table execution. This is achieved by combining categories from the question. When you select this command, the `Add calculated response` dialog appears. In `Name`, enter a description of the new response category. The list shows the responses in the question. In the list, double-click each response that you want to combine; they are added to the `Script` box. By entering mathematical operators in the `Script` box, between the response numbers, you control how the responses are combined. For example: `{1}+{2}` combines responses 1 and 2. `{1}-{2}` subtracts the total from response 2 from response 1.
Remove selection(s)	Removes the selected question or questions from the `Rows`, `Columns` or `Edges` (so it will not appear in the table). You can select multiple questions by holding down `CTRL` while you click, or multiple adjacent questions by holding down `SHIFT` and clicking the first and last questions you want to select.
Hide/display selected response(s)	Hide: Hides the selected response or responses from the `Rows`, `Columns` or `Edges` (so it will not appear in the table). Display: Shows the selected previously hidden response or responses from the `Rows`, `Columns` or `Edges` (so it will appear in the table). You can select multiple responses by holding down `CTRL` while you click, or multiple adjacent responses by holding down `SHIFT` and clicking the first and last responses you want to select.
Collapse the panel	Hides the panel (`Rows`, `Columns` or `Edges`). The panel moves to the right-hand edge of the screen, providing more screen space for the other panels or (if you hide the rows, columns and edges) the table view. To show a panel again, at the edge of the screen click `Expand the panel`:
Group responses This command is revealed if you click `More`:	Groups two or more response items together (in other words, the responses are combined). The new group will appear in your table but the individual items are hidden so they will not appear (although you can manually show them by selecting them and clicking `Display selected response(s)`). This command is available only if you have selected at least two response items. You can select multiple responses by holding down `CTRL` while you click, or multiple adjacent responses by holding down `SHIFT` and clicking the first and last responses you want to select.
Group with details This command is revealed if you click `More`:	Groups two or more response items together (in other words, the responses are combines). The new group will appear in your table and the individual items remain visible, so they will also appear. This command is available only if you have selected at least two response items. You can select multiple responses by holding down `CTRL` while you click, or multiple adjacent responses by holding down `SHIFT` and clicking the first and last responses you want to select.
Group and leave This command is revealed if you click `More`:	Groups two or more response items together. The items are placed into the new group, but also remain as separate items in the response list. This command is useful where you intend to include a response in more than one group, as the response remains in the list to be grouped again. By default, the individual items outside of the group remain visible, so they will still appear as separate items in the table, while the items within the group are hidden, so they will not appear in the table (although you can manually show and hide responses as you wish). This command is available only if you have selected at least two response items. You can select multiple responses by holding down `CTRL` while you click, or multiple adjacent responses by holding down `SHIFT` and clicking the first and last responses you want to select.
Ungroup This command is revealed if you click `More`:	Splits the selected grouping or groupings you have made previously into separate response items. You can select multiple groupings by holding down `CTRL` while you click, or multiple adjacent groupings by holding down `SHIFT` and clicking the first and last groupings you want to select.
Ungroup all This command is revealed if you click `More`:	Removes all first-level grouped responses. To remove all grouped responses, see `Flatten`, above.
Edit calculated response This command is revealed if you click `More`:	Allows you to change the definition or label of the selected calculated response. When you select this command, the `Calculated response` modal window appears. For more information, see Add calculated response.
Remove calculated response This command is revealed if you click `More`:	Removes the selected calculated response from the `Rows`, `Columns` or `Edges` (so it will not appear in the table).

Command name

Description

Save question/s in profile

Allows you to save all the questions in the appropriate panel (rows, columns or edges) to a Profile. You can save them to an existing Profile, or a new one.

When you select this command, the Save dimension to profile modal window appears. To save to an existing profile, select that profile in the list and click Save. To save to a new profile, in the Name input type a name for your new profile and click Save.

Move selection to...

icn-move-to-normal

Allows you to move the selected question or questions from the panel in question (rows, columns or edges) to another panel (rows, columns or edges). Simply select the destination panel (Rows, Columns or Edges) from the list that appears.

You can select multiple questions by holding down CTRL while you click, or multiple adjacent questions by holding down SHIFT and clicking the first and last questions you want to select.

Move items up

icn-up

Moves the selected item or items upwards in the list (and therefore upwards in the table). You can move entire questions, or responses within a question.

You can select multiple items by holding down CTRL while you click, or multiple adjacent items by holding down SHIFT and clicking the first and last items you want to select.

Move items down

icn-down

Moves the selected item or items downwards in the list (and therefore upwards in the table). You can move entire questions, or responses within a question.

You can select multiple items by holding down CTRL while you click, or multiple adjacent items by holding down SHIFT and clicking the first and last items you want to select.

Rename the selected item

icn-rename(2)

Allows you to rename the selected question or response, thereby changing how it appears in the table. Note that the original question or response name is not affected, only how this instance of it will appear in the table.

Select all

This command is revealed if you click More:

If you have a question currently selected, this command selects all questions in the panel (Rows, Columns or Edges).

If you have a response currently selected, this command selects all responses in the same question, allowing you to quickly activate a large number of response items. If you want to deactivate specific responses, click them while holding down CTRL (in Windows) or CMD (Mac OS).

Note that instead of clicking this command, you can also use the keyboard short-cut CTRL + A (if you are using Windows) or CMD + A (if you are using Mac OS).

Unselect all

This command is revealed if you click More:

If you have a question currently selected, this command un-selects all questions in the panel (Rows, Columns or Edges).

If you have a response currently selected, this command unselects all responses in the selected question, allowing you to quickly de-activate a large number of response items.

Locate

This command is revealed if you click More:

If you have a question or response currently selected in the rows, columns or edges panel, this command displays and selects that question in the question list in the left-hand pane. If the question is located inside a chapter, then the chapter (or chapters) are opened to allow the question to be displayed. This makes it easy to find questions within very large surveys.

Copy

This command is revealed if you click More:

Copies the selected question to the clipboard, so you can paste the presentation or structure (see below) onto another question.

Paste presentation

This command is revealed if you click More:

Paste the structure and formatting (bold, color, groupings, captions, etc.) of one question to another question.

Paste structure

This command is revealed if you click More:

Paste the structure (that is, any grouped and calculated responses) from one question to another without overriding the captions of the responses.

Flatten

This command is revealed if you click More:

Removes all grouped responses, both nested groups and un-nested. To remove just first-level grouped responses, see Ungroup all, below.

Add calculated response

This command is revealed if you click More:

Adds an additional category to the selected question, calculated on table execution. This is achieved by combining categories from the question.

When you select this command, the Add calculated response dialog appears. In Name, enter a description of the new response category. The list shows the responses in the question. In the list, double-click each response that you want to combine; they are added to the Script box. By entering mathematical operators in the Script box, between the response numbers, you control how the responses are combined. For example:

{1}+{2} combines responses 1 and 2.

{1}-{2} subtracts the total from response 2 from response 1.

Remove selection(s)

icn-remove(4)

Removes the selected question or questions from the Rows, Columns or Edges (so it will not appear in the table).

You can select multiple questions by holding down CTRL while you click, or multiple adjacent questions by holding down SHIFT and clicking the first and last questions you want to select.

Hide/display selected response(s)

icn-invisible-normal icn-visible-normal

Hide: Hides the selected response or responses from the Rows, Columns or Edges (so it will not appear in the table).

Display: Shows the selected previously hidden response or responses from the Rows, Columns or Edges (so it will appear in the table).

You can select multiple responses by holding down CTRL while you click, or multiple adjacent responses by holding down SHIFT and clicking the first and last responses you want to select.

Collapse the panel

Hides the panel (Rows, Columns or Edges). The panel moves to the right-hand edge of the screen, providing more screen space for the other panels or (if you hide the rows, columns and edges) the table view. To show a panel again, at the edge of the screen click Expand the panel:

Group responses

This command is revealed if you click More:

Groups two or more response items together (in other words, the responses are combined). The new group will appear in your table but the individual items are hidden so they will not appear (although you can manually show them by selecting them and clicking Display selected response(s)).

This command is available only if you have selected at least two response items. You can select multiple responses by holding down CTRL while you click, or multiple adjacent responses by holding down SHIFT and clicking the first and last responses you want to select.

Group with details

This command is revealed if you click More:

Groups two or more response items together (in other words, the responses are combines). The new group will appear in your table and the individual items remain visible, so they will also appear.

Group and leave

This command is revealed if you click More:

Groups two or more response items together. The items are placed into the new group, but also remain as separate items in the response list. This command is useful where you intend to include a response in more than one group, as the response remains in the list to be grouped again.

By default, the individual items outside of the group remain visible, so they will still appear as separate items in the table, while the items within the group are hidden, so they will not appear in the table (although you can manually show and hide responses as you wish).

This command is available only if you have selected at least two response items. You can select multiple responses by holding down CTRL while you click, or multiple adjacent responses by holding down SHIFT and clicking the first and last responses you want to select.

Ungroup

This command is revealed if you click More:

Splits the selected grouping or groupings you have made previously into separate response items.

You can select multiple groupings by holding down CTRL while you click, or multiple adjacent groupings by holding down SHIFT and clicking the first and last groupings you want to select.

Ungroup all

This command is revealed if you click More:

Removes all first-level grouped responses. To remove all grouped responses, see Flatten, above.

Edit calculated response

This command is revealed if you click More:

Allows you to change the definition or label of the selected calculated response. When you select this command, the Calculated response modal window appears. For more information, see Add calculated response.

Remove calculated response

This command is revealed if you click More:

Removes the selected calculated response from the Rows, Columns or Edges (so it will not appear in the table).