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.

2. Background

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

3. Font style

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

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

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.

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.

5. Indent from parent

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

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.

7. Total row

Enable this option to display the aggregated 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.

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.

9. Major gridlines

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

10. Minor gridlines - horizontal

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

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

• 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).

11. Minor gridlines - vertical

Set the color and thickness of the vertical gridlines. Choose the 'Off' option to disable 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+.

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

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.

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.

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

15. Category grouping

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

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

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.

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