Tables - canvas settings
Last updated
Last updated
The canvas tab enables you to set the theme, assign chart colors, customize the variance, or change the font for the entire report.
Analytics+ comes packed with built-in themes you can apply in a single click. Select the theme from the dropdown to apply it.
You can set a custom background color for the canvas. It is set to white by default.
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.
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.
You can set the indentation of child rows with respect to the parent. Values between 1 and 25 are accepted.
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.
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.
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.
Assign the color and thickness for major gridlines. Choose the 'Off' option to disable major gridlines.
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).
Set the color and thickness of the vertical gridlines. Choose the 'Off' option to disable vertical gridlines.
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.
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.
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.
When the category grouping toggle is disabled, the hierarchies are displayed as paths rather than parent-child categories.
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.
Choose from Hierarchical(default), Stepped, Outline, and Table layouts.
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.
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.
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.
