Skip to Content

Chart types

Set up a table

Show rows and columns with a Table or a Horizontal Stack Table, and style them.

Show the result as rows and columns. Horizontal Stack Table adds a stacked bar in each row.

What the data needs

ChartDimensionsMeasures
TableAnyAny. Every field is a column.
Horizontal Stack Table1 or more, the rows1 or more, the stacked bar

Steps

  1. Add the fields to Dimensions and Measures.

  2. In the chart toolbar, select Chart type, then Table or Horizontal Stack Table.

    Chart type picker with the Table tile highlighted
    Table in the Chart type picker.
  3. Select Appearance.

  4. Open a section and change the settings.

    Chart settings for a table with the Features section open and Pagination highlighted
    Features has Pagination, Table search, Sorting and more.
  5. Select Done.

Sections

SectionWhat you setCharts
UI stylingTable title, header, text wrap, content font, list and badge columns, dividers, striped rows, borders, Fit contentBoth
Conditional formattingColor the cells whose values meet a conditionBoth
FormattingNumber format, prefix, suffix and date format per columnBoth
Aggregate rowA total row, with a Label, Type and ColumnsTable
Bar stylingBar width, Top radius, Bottom radiusHorizontal Stack Table
FeaturesPagination, Server side pagination, Table search, Sorting, Column filters, View details, Transpose dataTable

Color cells with a rule

  1. Open Conditional formatting and add a rule.
  2. Choose the Columns and the Condition.
  3. Enter the value to compare with.
  4. In Color applies to, choose Background or Badge.
  5. Choose the colors.

With Transpose data on, the Formatting and Aggregate row sections are hidden.

Reset to default and Set as workspace default do not show for tables.

Next: set up a pivot table.