Skip to main content

Table Visualizations

Omni offers many ways to configure tables for more visual sharing, including layout controls, in-line visualization, conditional formatting, and other controls.

Overall Table Options​

Column Width​

This allows toggling between a full width table (stretch) and a smaller table where whitespace pushed to the right of the table (condensed).

Show / Hide View Names​

This will toggle whether or not to show the view name in the results table.

Show / Hide Column Totals​

This will toggle totals for each measure at the bottom of the table (note, dimensions will not be totaled).

Show / Hide Row Totals​

This will toggle row totals for each measure at the right of the table. This option is only available with pivots in the query.

Swap Rows and Columns​

This will transpose the table (for when measures are needed across rows). There are some UX restrictions on the transposed table, for example column sort is only available prior to transpose.

Column-Specific Controls (in Table Options)​

Show / Hide Columns​

To hide columns from the result table, simply click the eye in the column options:

Pivots can also be hidden, but must be hidden from the table itself (see below).

Conditional Formatting​

Numeric values can be colored based upon the distribution of values using conditional formatting. To active conditional formatting, simply select the desired series. By default Omni will select three palettes and graident in between the min and max values. This can be adjusted to a color pair, or more colors as desired.

Additional options are available to treat nulls as 0 or exlude them from the color palette:

Visualization in the Table​

For numeric columns, bars can optionally be displayed alongside the values to more quickly show relative sizes.

These are set through the 'bar' config on each column indepedently:

Column-Specific Controls (in Table)​

Show / Hide Columns​

To hide columns from the result table, right click on any column in the result set from the table visualization configuration. Hidden columns can then be returned from the configuration. Columns may also be hidden from the table options menu.

Pivots can also be hidden, and will be indexed to the value of the pivoted series. This means if you hide the first pivot, say status: Returned, the hide is not indexed to the first pivot, but rather Status: Returned.

Subtotals​

Subtotals allow totals across subsets of the full result set (for example Year, Month). To set subtotals, use the column menu to select subtotal, which will subtotal all columns to the left of the selected dimension:

Columns Re-Sort / Column Reorder​

Columns in the data table can be re-arranged using the drag target on each column header. Pivots can only be re-arranged via re-sort, not on an ad hoc basis. Note that dimensions and measures can be interspersed if there is no pivot.

Pivot Sorting​

Pivots can be sorted the same way that columns are sorted, by clicking on the field header in the data table. Pivots can also be sorted based on values in the data table by clicking the row number, including by the total (clicking the blank row number for totals).