Tables display a Dashboard Tile in a format similar to a spreadsheet, with support for rearranging, resizing, sorting, and formatting columns.Tables display your Dashboard Tile in a format similar to an Excel spreadsheet. In table view, your search identifies attributes and/or columns and presents them as a table, aggregated based on the level of aggregation you specify. For example, searching only
revenue shows the total sum of revenue as a single number; adding the keyword monthly breaks the results down by month.
From the column header, you can rename, sort, or filter a column. Rearrange column order by dragging and dropping columns, either from the table itself or from the Edit table: Configure menu, and change column widths.
Rearrange column order
- While viewing your Dashboard Tile as a table, click the column header you want to move.
- Drag it to its new position.
Resize column widths
Hover over a column border in the header row, then click and drag to your preferred width. Adjustments save when you pin the table to a Dashboard.Clip or wrap text
Clip or wrap long text in a table cell or header, for the entire table or column by column. Clipped text shows only the beginning, with the rest visible if you widen the column; wrapped text shows all the text by increasing the number of lines. To clip or wrap the entire table, click the edit table configuration icon, select Settings, and under text wrapping choose wrap or clip. To do it for one column, hover over the column name, click the more options menu icon, select text wrapping, and choose wrap or clip.Number formatting
Format the numbers in any table column based on a Measure, changing the category (number, percentage, or currency), units (auto, none, thousand, million, billion, or trillion), or method of writing negative values (-1234, 1234-, or (1234)).
- Click the edit table configuration icon. The Edit table panel appears on the Configure menu.
- Select the Measure to format (or use the more icon that appears when hovering over a column name).
- Under number formatting, edit the category, units, or negative-value method from the dropdown menus.
- Specify a category: number, percentage, or currency (choosing currency lets you pick a currency type). If you don’t pick one, Invoca automatically picks the best category for your data.
- Specify units: none for two decimal points, or millions for labels rounded to the millions, for example. If unspecified, Invoca picks the best units automatically. Depending on the unit, you can also set decimal places and the thousand separator.
- Specify the negative values format:
-1234,1234-, or(1234). The default is-1234.
Sort columns
Click a column title to sort by it. Hold Shift and click another column title to add a secondary sort — you can add tertiary sorting the same way. This is especially useful for date columns. You can also sort from the search bar, by addingsort by date quarterly or sort by date weekly.
TipThis same functionality is available on tables elsewhere in Invoca — for example, a table on the Data page is also sortable this way.