Visual

Design pane, toolbar

Visuals are dynamic data visualizations designed to effortlessly generate visual reports. They can be created similarly to other snippets by selecting the type as Visual. The design pane closely resembles that of a report snippet, with the primary distinction lying in the layout. In an input sheet and report, you work with rows and column axes, while a visual employs Axis (Categories) and Legend (Series). The filter functionality remains consistent across all snippet types.

Once the visual layout is established, it is mandatory that both the axis and legend fields are populated; they cannot be left blank. Filters, on the other hand, are optional. Depending on the chosen layout, the system will provide recommendations and automatically generate a visual representation of the data. Any further customization of the visual can be managed via the Toolbar, which is situated in the level 2 header.

Charts : This section contains all available visualization types. When expanded, there are four major categories, with each category containing a specific set of visualization types.

Comparison

Stacked bar chart : Represents data using stacked bars to show the composition of various categories.

Clustered bar chart : Displays multiple bars for each category, allowing easy comparison between different groups.

Clustered column chart : Similar to clustered bar chart but using vertical columns.

100% stacked bar chart : Illustrates the relative proportions within each category by stacking bars to total 100%.

100% stacked column chart : Similar to the 100% stacked bar chart but with vertical columns.

Line and stacked column : Combines a line chart with stacked columns to visualize trends and composition simultaneously.

Polar chart : Displays data points along radial axes, useful for comparing values across multiple categories.

Line and clustered column : Combines a line chart with clustered columns for comprehensive data representation.

Waterfall Chart : Visualizes data changes step by step, making it easy to track how values accumulate or diminish.

Trend

Line chart : A line chart uses lines to connect data points, making it ideal for visualizing trends and changes over time or categories.

Area chart : An area chart fills the space below a line chart, emphasizing the magnitude of change over time or categories while maintaining the underlying trend.

Stacked area chart : A stacked area chart combines multiple area charts, showing the contribution of each category to the total, making it useful for visualizing composition and trends simultaneously.

Compostiton

Pie chart : A pie chart displays data in a circular form, with slices representing different categories and their proportions relative to the whole.

Doughnut chart : Similar to a pie chart, a doughnut chart is a circular graph with a hole in the center, making it easy to compare proportions within categories.

Half doughnut chart : A half doughnut chart is a semi-circular version of the doughnut chart, providing a compact way to represent data while retaining the ability to compare proportions within categories

Indicator

Card : A card visualization displays a single value or statistic, making it easy to emphasize and focus on a specific data point.

Multi-row card : A multi-row card allows you to display multiple values or statistics in a tabular format, providing a concise summary of data.

KPI : A KPI visualization highlights critical metrics or performance indicators, often using visuals like gauges, icons, or numerical values to convey data-driven insights.

Multi row KPI : Similar to a KPI, a multi-row KPI displays multiple key performance indicators in a tabular format for a comprehensive overview.

Gauge : A gauge visualization represents data using a visual gauge or dial, offering a clear and intuitive way to display progress, levels, or performance against predefined thresholds.

The currently selected visualization type is highlighted. Valid visualization types that are applicable to the current snippet appear in black, while types not suitable for the current selection appear in grey.

Colors : A color theme can be applied to the visual using predefined color sets. These sets are designed to provide a consistent and aesthetically pleasing color palette for the visualizations, improving their visual appeal.

Add Chart Elements : following are the chart elements

Chart element	Description
Title	Options include hiding it, and adjusting its alignment (move left, right, or center)
Legend	Choose to hide it or change its placement (move left, right, or center)
X-Axis Labels	Toggle visibility, and select vertical labels if needed
X-Axis Title	Show or hide the X-axis title.
Y-Axis Labels	Decide whether to display or hide Y-axis labels.
Y-Axis Title	Show or hide the Y-axis title.
Gridlines	Options include hiding them or selecting from different styles (dotted, solid, or dashed)
Data Labels	Choose to hide them or position them outside, inside, or inside center
Zoom	Toggle the zoom bar at the bottom of the visual for precise analysis

Show/ Hide Table : allows for disabling the table containing snippet data.

Axis Limit : Axis limits impose restrictions on the number of axes/series refresh, with a maximum limit of 50.

Series Limit : The Series Limit is capped at a maximum of 20.

Spreadsheet Element : choices include showing or hiding the grid, column headers, and row headers.