Results that are tables

You can rearrange the column order of your table after adding all of your search terms.

To rearrange the column order:

You can also rearrange the column order from the Edit table: Configure menu. Click the edit table configuration icon . Drag and drop the attribute or measure that you would like to move to a new position. The order of columns in the Configure menu reflects the column order of the table.

You can resize the column widths of your table after adding all of your search terms. Any adjustments you make to the column widths of your table are saved when you pin the table to a Liveboard. To resize the column widths:

You can clip or wrap long text in a table cell, or on a table header. You can configure clipped or wrapped text for the entire table, or for each column individually.

When you clip long text, the table cells show only the beginning of the text. The rest appears if you increase the column width.

When you wrap long text, the table shows all the text in its cells by increasing the number of lines in the cells.

To clip or wrap text for the entire table, click the edit table configuration icon . Select Settings. Under text wrapping, choose wrap or clip.

To clip or wrap text for each column individually, hover over the column name and click the more options menu icon . Select text wrapping, and choose wrap or clip.

You can format the numbers in any table column or column summary based on a measure. This functionality allows you to change the category (number, percentage, or currency), units (auto, none, thousand, million, billion, or trillion), or method of writing negative values (-1234, 1234-, or (1234)).

To change the number formatting:

You can perform conditional formatting on both measures and attributes, within table cells and in the table summaries.

Refer to Apply conditional formatting.

Note that certain elements of conditional formatting are part of the new answer experience. These elements include conditional formatting for table summaries and improved conditional formatting for attributes and measures in table cells. The new answer experience is off by default. You can toggle it on or off from the Experience manager in your profile. If that option is not available, contact your administrator.

You can sort a table by column values by clicking on the column title. If you hold down the SHIFT key, you can sort on multiple column titles at a time. This is especially useful for date columns. For example, if you search for sales by week and by quarter, and just sort the quarterly column, the weeks are not in order:

If you press SHIFT and then click on the weekly column header, the weeks are in order, by quarter:

You can achieve this from the search bar, as well, by adding sort by date quarterly and sort by date weekly.

Tables automatically have footers that tell you the number of rows the table has. You can enable or disable this footer from the Settings menu.

Content density is part of the new answer experience, which is off by default. You can turn it on or off from your profile. You can view more table rows at a time by changing the content density. You can change the content density from the Settings menu.

Table themes are part of the new answer experience, which is off by default. You can turn it on or off from your profile. You can change the table theme from the default (outline) to row or zebra. You can change the table theme from the Settings menu. Row removes the lines between columns, and zebra changes the color of every other row.

For columns with numeric information, you can turn on column summaries that display column totals. You can perform number and conditional formatting on column summaries, just like you can for column values.