How to Use the Table


To create a new table:

  1. On the authoring bar, click    to open the Visualization types flyout.

  2. Drag the Table visualization to the wanted position on the analysis page.

  3. Response: A table visualization showing all available columns is created.

  4. Adjust the table to display the columns and sort order of your choice.

To change the order of the columns:

  1. Click a column header and drag it horizontally to the desired position.

    Tip: You can place a column furthest to the left or furthest to the right in the table by clicking the column header and selecting Move first or Move last in the pop-up menu.

    Comment: You can also go to the Columns page in the Properties dialog and click a column in the Selected columns list and then click Move Up or Move Down to change the order of the columns.

To change the width of an individual column:

  1. For the column you want to resize, place the cursor on the column divider to the right of the header. The cursor changes appearance.

  2. Click and drag the cursor horizontally to the wanted column width. A red vertical line is shown to indicate the width.

    Note: It is possible to specify an exact width in pixels. Click the column header, and in the opened pop-up menu, type the wanted number of pixels in the Column width field. Then press Enter.

    Tip: To optimize the use of the screen estate with content kept visible for the column, you can double-click the column divider to adapt the column width to the content. Alternatively, click the column header, and in the opened pop-up menu, select Size to fit.

To change the column widths of all columns simultaneously:

You can simultaneously change all column widths to the same size, or to the smallest possible widths.

  1. Place the cursor on any of the column dividers between the column headers.

    Response: The cursor changes appearance.

  2. Press Ctrl, and click and drag the cursor horizontally. A red vertical line indicates the width.

    Response: The new column width is applied to every column in the table.

    Tip: To optimize the use of the screen estate for the entire table, you can right-click the visualization, and select Resize Columns to Fit. This action will make the column widths as small as possible. That is, every column adjusts automatically to the smallest size that keeps all the table content fully visible.

To change row height:

  1. Place the mouse pointer between two rows in the table, press and hold the mouse button.

  2. Adjust the height by dragging the red line to the desired row height, then release the mouse button.

    Response: The rows in the table adjust to the new height.

    Note: The height of the header row is adjusted separately.

To specify the header orientation and header text alignment:

The headers can be displayed horizontally or vertically. By changing to a vertical header for narrow columns, the screen estate can be used more efficiently. In addition, you can specify the horizontal and vertical alignment of the text within the header.

  1. Click a column header that you want to adjust orientation or text alignment for.

  2. In the opened popover, beneath Header, select the Style this header individually check box, if you want only this column header to be adjusted. If the check box is not selected, all column headers are adjusted.

  3. Use the buttons beneath Header to specify the horizontal and vertical alignment of the header text, and the header orientation.

    Response: The orientation of the header and the alignment of the header text for the column or columns in question are adjusted accordingly.

To specify the horizontal text alignment for table cells:

You can specify the text alignment for all table cells or for the cells in an individual column.

  1. Click the header of a column for which the text alignment in the table cells should be changed.

  2. In the opened popover, beneath Values, select the Style this column individually check box, if you want only the table cells in this column to be adjusted. If the check box is not selected, the text alignment is adjusted in all table cells.

  3. Click the tick mark (default), Left, Center, or Right button to specify the horizontal alignment.

    Response: The horizontal alignment of the table cell texts in the column or columns in question is adjusted accordingly.

To specify text color, background color, and font style in the table:

You can specify the text color and background color, as well as font style for an individual header, all headers, an individual column, or all table cells.

  1. Click the header of a column for which you want to change the text style.

  2. Response: A popover is opened. It contains styling options categorized in different sections for Header and Values.

  3. Hover the mouse pointer over the Header and Values sections. To guide you, the parts of the table that will be affected by the selections you make, will be highlighted.

  4. Make the text styling selections of your choice, for example text color or background color , and then close the popover by clicking outside the popover.

  5. Comment:  If you want the text styling settings to be applied to one single header or column, select Style this header individually or Style this column individually respectively.

To apply value-based coloring:

See Coloring in Tables to learn how to set up coloring for tables specifically. See Coloring Overview if you want to learn more about coloring in general.

Note: The table can also be styled with different text color and background color on specific headers and columns, without any connection to the cell values. See To_specify_text_color_background_color_and_font_style_in_the_table.

To hide a column:

  1. Click a column header and select Hide column in the pop-up menu.

    Comment: To make a hidden column visible, see To add columns below.

To add columns:

  1. Right-click the table visualization and select Properties.

  2. Select the Columns page in the dialog.

  3. Select the columns you want to insert from the Available columns list.

  4. Click Add >.

    Response: The column is inserted to the right of all previously added columns.

    Comment: Click a column in the Selected columns list and then click Move Up or Move Down to change the order of the columns.

  5. Click Close.

To freeze certain columns when scrolling horizontally:

In a table with many columns you often need to scroll horizontally. However, there may be certain columns you want to see regardless of scrolling. This is achieved by freezing one or more columns.

  1. Move the columns you want to freeze to the left side of the table.

  2. Right-click the table visualization and select Properties.

  3. Select the Appearance page of the dialog.

  4. Specify the Number of frozen columns you want, counting from the left-hand side of the table.

  5. Click Close.

To show text as hyperlinks:

  1. It is possible to show the contents of a column as clickable links. To do this, right-click the table visualization and select Properties.

  2. Select the Columns tab.

  3. Select the column you want to contain links.

  4. Select Link from the Renderer drop down list.

  5. Click Settings.

  6. Specify the settings in the Link Renderer Settings dialog and click OK.

  7. Click Close.

To sort the table:

You can sort the rows in the table by the values in one or more columns.

  1. Click the header of the column containing the values you want to sort by.

  2. In the opened pop-up menu, beneath Sorting, click to sort from lower to higher values, or click to sort from higher to lower values.

    Response: The data rows are sorted by the column values, and an arrow in the column header indicates the order.

    Comment: You can click the column header while pressing Shift to switch between the sorting modes.

  3. If you want to continue sorting the table by the values in another column, click that column header while pressing Shift + Ctrl.

    Response: Within each group of equal values that might be the result of the first sorting, the rows are sorted by the values in this second column in an ascending order.

  4. Repeat step 3 to sort by subsequent columns.

    Comment: If you press Shift + Ctrl while clicking an already sorted column, the sort order changes to descending.

    Tip: An alternative way to sort the table is to right-click the table, and open the Properties dialog. On the Sorting page, you can specify up to three columns to sort by.

To mark rows:

Note: When marking in a table visualization, you may need to specify key columns to be able to reapply markings when reloading data. See also Working with In-Database Data, if you create analyses using external data.

To mark a single row:

Either click the row with the mouse, or use the up/down arrow keys on your keyboard.

To mark several separate rows:

Hold the Ctrl key and click each row you want to add to the marked selection. You can also hold the Ctrl key and use the up/down arrow keys on your keyboard to highlight other rows and then press space to mark them as well.

To mark a range of rows:

Press the mouse button and drag the pointer over the table to mark all the rows under the selection. You can also mark the first row of your intended selection, hold the Shift key, and use the up/down arrow keys on the keyboard to expand the selection of marked rows.

To change the color of the marked rows:

Select File > Document Properties, the Markings tab. Select the marking in question, and click Edit. Pick another Color using the drop-down list, and click OK.

To copy a cell:

See also:

What is a Table?

Table Properties

Images in Tables

Virtual Columns