Customizing tables

Follow

If you do not want to display results on a graph, you can select the tables chart type. Tables will create columns for your results based on their location on the frame. Below is an example with the Revenue and Cost Goods on Metrics, Quarter(Date) on Columns, and Category on Rows.

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

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

If you add a URL to your table, you can change URL options in Chart as well. If you would like to make your URL live you can select Clickable url. 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. If you do not want the original URL to appear, you can add an alias for both the URL and image URL.

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 Columns.

The following are the available customization options in 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 Metric 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 enables users to 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, fourth, and seventh columns to become empty. In the image below, those columns have been hidden.

Color options

Lastly, 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 pre-configured color palettes. Below is an example of how colors can be used to highlight your results.

Have more questions? Submit a request

2 Comments

Please sign in to leave a comment.
Powered by Zendesk