Customizing tables

If you don't want to display results on a graph, you can display your results in a table. Tables create columns for your results based on their location on the frame. Below is an example with Tickets and Replies as metrics, Quarter(Ticket Created At) as a column, and Ticket Type as a row.

Note: You can switch the column and row attributes by clicking the Pivot table button () to the right of the Columns panel. This saves you time by automatically moving your attributes, so you don't have to drag and drop.

Even though tables have a simple default view, you can use customization options to enhance your table.

In the chart configuration menu (), the following areas contain customization options:

Chart

Text style options include editing the size, color, and formatting for headers, results, totals, and subtotals. If you add totals or subtotals, you can change their labels and their repetition text.

If your dataset or labels include URLs, you can select the HTML option from the Text interpretation drop-down list to edit URL settings. You can click the Clickable url checkbox to permit viewers to open your URL. If you do not want the full URL to appear, you can enter an alias in either URL alias or Image URL alias

If your URL points to an image, the image will automatically appear when a user hovers over the link. You can disable this by deselecting Display images.

Columns

Columns will be added to your table every time you place an attribute or metric on the frame. You can edit these column options in Chart configuration>Columns.

Adding metrics to rows

By default, metrics will be placed in different columns. You can list the metrics together in one column by selecting Metrics on rows.

If you've selected Metrics on rows or added an attribute on Rows, you can display the number of rows in your table. You can also apply your sorting filter by selecting Allow sort on row number.

Settings column width

Your columns will be fitted to their content and aligned automatically, unless you change these options in Columns. To input a new width and alignment for individual columns, you must deselect Fit to content and Automatic alignment.

Expanding text

If you select a column width that removes a portion of your text, you can expand your text onto additional lines by checking Allow multiline. You can set the number of lines by typing a new number in multiline margin.

If your text exceeds the selected number of lines, you can check Discoverable multiline. Discoverable multiline lets you expand text by clicking a Read More link.

Hiding columns

In the column list, you can also select whether to show or hide columns and add an arrow to stress the direction of results. Hiding columns can be useful when you want to remove empty or unnecessary columns.

For example, in the report below the result path calculation calculates the percentage of difference based on the previous period. This causes the third column to become empty. In the image below, the column has been hidden.

You can hide columns by clicking the eye icon next to the column number.

Color options

You can customize the colors of your table in Colors. You can edit the background, header, rows, totals, subtotals, and table colors. You can choose your own colors or select from Explore's color palettes.