Tables - canvas settings

The canvas tab enables you to set the theme, assign chart colors, customize the variance, or change the font for the entire report.

1. Theme

Analytics+ comes packed with built-in themes you can apply in a single click. Select the theme from the dropdown to apply it.

Setting the theme for tables

With Analytics+, you can customize themes by setting the measure/font/background colors. You can design a custom theme by navigating to Canvas settings > Theme > Customize.

2. Background

You can set a custom background color for the canvas. It is set to white by default.

Canvas background

3. Font style

Set the font type, size, and color. To set a custom font color, the Auto color toggle should be disabled.

Setting the font for tables

• Auto color: Analytics+ can adjust the font color for optimal visibility when this option is enabled. In the example below, notice how the font color is not visible against the color scales when the Auto Color option is turned off.

Auto Color

Responsive: When this option is enabled, Analytics+ will dynamically adjust the font size based on the canvas size. The font size will be reduced as you decrease the canvas size, enabling you to fit in as much data as possible and optimize the available canvas area.

Responsive font enabled

Title size reduced when responsive font is disabled

4. Row highlight

You can choose from multiple options to highlight rows and make your tabular data more readable.

• Uniform: Set a single color for all the rows. Enable the Apply to row header option to apply the same color to the row categories.

• Individual: You can apply a different color to highlight and distinguish between the rows and the row categories.

• Row alternate: You can specify different colors for alternate rows. Enable the Apply to row header option to apply the same color scheme to the row categories.

Row highlight options

5. Indent from parent

You can set the indentation of child rows with respect to the parent. Values between 1 and 25 are accepted.

Indentation from parent

6. Sync panel scroll

Analytics+ facilitates comparative analysis with synchronized horizontal & vertical scrolling. When you scroll through one trellis panel, the other panels scroll automatically.

Note: In the gif below, we have enabled synchronized scrolling using the toolbar icon. You can enable it from the canvas settings side pane as well.

Synchronized scrolling

7. Total row

Enable this option to display the aggregated total row.

Calculate total row

• Charts on grand total/variance grand total: You can decide whether to render charts for the grand total row. Disable these options if you do not want charts in the grand total.

Display charts in grand total

8. Outline

You can set an outline that demarcates the headers, rows, and the data. When the outline toggle is enabled, you can assign a color as well.

Outline option

9. Major gridlines

Assign the color and thickness for major gridlines. Choose the 'Off' option to disable major gridlines.

Major gridlines - single

Major gridlines - double

10. Minor gridlines - horizontal

Assign the color and style for horizontal minor gridlines. Choose the 'Off' option to disable minor gridlines.

Minor gridlines horizontal - solid

Minor gridlines horizontal - dashed

• Header

Enable the Header toggle to set gridlines for the header row. You can set a custom color to distinguish between the header and data.

Header gridlines

• Skip lines

Set the number of rows between consecutive horizontal gridlines. In the example, the gridline is rendered after every 2nd row instead of after every row (default option).

Skip lines

11. Minor gridlines - vertical

Set the color and thickness of the vertical gridlines. Choose the 'Off' option to disable vertical gridlines.

Vertical gridlines

12. Axis default date format

When you have a date dimension as your axis, you can double-click on the category and choose from the date formats supported in Analytics+.

Axis default date format

When this option is disabled, the date format is taken from the system settings.

Axis date format from system

13. Group default date format

Like the Axis default date format option, when you have a date dimension as a small multiple parameter, you can choose to use the system date format or use the default Analytics+ format.

Group default date format enabled

Group default date format disabled

14. Ragged hierarchy

In real-life business scenarios, not all hierarchies are balanced and symmetrical. Analytics+ provides extensive support for hierarchical datasets. When you have blank categories in your hierarchies, you can choose whether to suppress or display them using the Ragged hierarchy option.

Blank rows displayed when ragged hierarchy is disabled

Notice how blank rows are suppressed when the Ragged hierarchy option is turned on.

Ragged hierarchy enabled

15. Category grouping

When the category grouping toggle is disabled, the hierarchies are displayed as paths rather than parent-child categories.

Category grouping disabled

• Single child: The single child option can customize how you display single node hierarchies, i.e., when a parent hierarchy has only one child. You have options to hide leaf nodes, hide all nodes if they are single children, or hide the parent node and display the leaf node directly if it has just one child. Learn more about working with hierarchies.

Single child options

16. Category expand collapse

• Total position: You can display the subtotal row before the child rows (choose the 'First' option) or at the bottom, after the child rows (choose the 'Last'). This option is enabled only when Category grouping is on.

Total position

17. Data table layout

Choose from Hierarchical(default), Stepped, Outline, and Table layouts.

Hierarchical layout

Outline

Table

Stepped

18. Row subtotals

You can customize the sub-total row by adding the parent category as a prefix/suffix, and enter a custom row header name in the Title textbox.

In this example, we've used the category as the prefix and "$value" as the text.

Row subtotals customization

19. Show blank label

When the Ragged hierarchy option is disabled, blank categories in your hierarchies will be displayed. You can choose to display these records with a '(Blank)' identifier.

Show blank label