Skip to main content Skip to complementary content

Table

The table shows several fields simultaneously, where the content of each row is logically connected. Typically, a table consists of one dimension and several measures.

Table visualization

You only make selections in the dimension columns. All dimension columns have a search icon Search in the header.

When to use it

Use a table, when you want to view detailed data and precise values rather than visualizations of values. Tables are good when you want to compare individual values. Drill-down group dimensions are very efficient in tables. Within a limited space, you can drill down to the next level of detail and analyze the updated measure values.

Advantages

You can filter and sort the table in different ways. Many values can be included in a table, and when you drill down in a table, you make good use of a limited space of the sheet. A table is excellent when you want to see exact values rather than trends or patterns.

Disadvantages

If the table contains many values, it is difficult to get an overview of how values are related. It is also hard to identify an irregularity within the table.

Creating a table

You can create a new table on the sheet you are editing.

  1. From the assets panel, drag an empty table to the sheet.
  2. Click Add dimension and select a dimension or a field.
  3. Click Add measure and select a measure or create a measure from a field.

When you have created the table, you may want to adjust its appearance and other settings in the properties panel.

Tip noteColumn width is automatically set to keep columns together for improved readability. You can adjust the width of a column by dragging the header divider. Double-click the header divider to reset to the default width.

Aligning data

If Text alignment is set to Auto, column data is aligned according to data type: text values are left-aligned and number values, including date related values, are right-aligned. If you set it to Custom, you can align the data to the left, center, or right.

Sorting the table

You can adjust the sorting of the table in several ways:

  • Column sorting: adjust the order of the dimensions and measures from left to right
  • Row sorting: adjust the sorting priority order of the rows
  • Internal sorting: use the internal sorting order of dimensions and measures
  • Interactive sorting: during analysis you can click on a column header to sort the table

Column sorting

By default, the order in which columns are sorted is set by the order in which dimensions and measures are added to the table. If you add the measure Sales first, it is presented first (leftmost) in the table. The next dimension or measure that is added is presented in the second column, and so on. The column sorting order can be changed in the properties panel, under Columns.

Row sorting

By default, rows are sorted by the first added dimension or measure, numeric values descending, text values ascending. A small arrow under the column header shows by which column the table is sorted.

You can change the row sorting in the properties panel, under Sorting. Drag the dimensions and measures to change the sorting priority order. In many cases, sorting is not only affected by the first dimension or measure in Sorting, but also the following ones.

Example:  

In the following screenshot, the rows are first sorted by Customer, then by Month, and then by Product Type. As you can see, the columns Customer and Month have several rows with the same values (A-2-Z Solutions and Month). The rows in Product Type are ordered alphabetically, but only those that were sold in January to the customer A-2-Z Solutions are displayed.

Table with sorting order: Customer, Month, Product type.

By changing the sorting order, so that secondary sorting is by Product Type, followed by Month, all Product Type items sold to the customer A-2-Z Solutions are presented in alphabetical order, whereas only the months when they were sold are displayed under Month.

Table with sorting order: Customer, Product type, Month.

Internal sorting

Each dimension and measure has a default (Auto) internal sorting order, which can be changed. Under Sorting, click the item you want to change and click the button to switch to Custom sorting. Changes made to the internal sorting of an item may not have any effect if the sorting is in conflict with an item with higher priority.

Interactive sorting

During analysis, you can set which column to sort on by clicking the column header. The first click sorts the table according to the default sorting of the selected item. A second click reverses the sorting order. Interactive sorting is session based and is not saved. If you want your changes to the sorting to be persistent, you need to make the changes in the properties panel.

Displaying totals

By default, the totals of numeric values are displayed under the column names. In the properties panel, you can change this to display the totals at the bottom of a column, or not at all.

Displaying more data

You can freeze the first column from scrolling, and select to wrap multiline text in headers and cells separately. These settings are changed in the property panel under Appearance > Presentation. You can also disable horizontal scrolling, and enable the column picker feature. This lets app consumers change table column order.

Adding a trend indicator to a measure

You can add a trend indicator to a measure column. This will show a symbol next to the measure value. You can define the ranges that determine which symbol is displayed and in which color it is displayed. You enable the indicator by setting Representation to Indicator in the measure properties.

Setting the indicator limits

You need to add the limits for the ranges you want to use for showing indicators with Add limit. You can set a limit value in three ways.

  • Use the slider.
  • Type a value in the text box.
  • Set an expression that returns the limit value.

When you have added the limits, you can select the color and the symbol of the indicator for each defined range.

Styling the indicator

You can style the way the indicator is displayed.

  • You can show both the indicator and the measure value by selecting Show values.
  • You can set the value color to the same as the indicator color with Apply color to value.
  • You can display the indicator to the right or to the left of the value with Indicator position.

Example

In this example, we added a trend indicator to the Sales measure to indicate which values are below the target value. The indicator limits are:

  • For values below 3000000 a red flag is displayed.
  • For values in the range of 3000000 to 3500000 a yellow flag is displayed.
  • For values above 3500000 a green check-mark is displayed.

Table with trend indicators

Adding a mini chart to a measure

You can add a mini chart to a measure column. This will show a small chart visualization instead of the measure value. You can define the dimension that determines what data is displayed and in which color it is displayed. You enable the indicator by setting Representation to Mini chart in the measure properties.

Setting the mini chart type

After specifying which dimension the mini chart will be based on, you must select a Mode.

  • Bars creates a bar chart.
  • Dots creates a dot chart.
  • Sparkline creates a sparkline chart. You can show dots at each data point along the sparkline chart by selecting Show dots.
  • Positive/negative creates a chart with each value represented by a dot above or below the zero.

When you have selected the mode, you can specify the Y-axis of the Mini chart at the bottom of the mini chart options.

Styling the mini chart

You can set the color of bars or lines for Bars, Dots, and Sparkline.

  • You can optionally set the Max value color and Min value color, which will highlight the highest and lowest visible chart values.
  • You can optionally set the Highlight first and Highlight last colors, which will highlight the first and last visible chart values.

You can set the positive and negative color for a Positive/negative mini chart.

Display limitations

Number of rows and columns

In a table, you can have millions of rows and virtually any number of columns with dimensions and measures. But because huge tables are impractical and hard to manage, the limit for what is practical is far less than the theoretical maximum. In most cases, it is desirable to see all the columns without scrolling horizontally.

Tables with content of mixed sizes

In a table you can have both columns where the content fits on one row within the cell, and columns containing wrapped multiline text. In some cases you will see a shift in alignment and number of rows when the multiline column is scrolled in and out of view. When the view only contains content that fits on one row, the table will adjust and show all content on single line rows, which means more rows are displayed.

We recommend that you disable multiline text wrapping in these cases to avoid confusion for the user.

Related learning:

Learn more

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!