Grid

In ViewZen Analytics, tables are an essential visual component used to present data in a structured, grid-like format. They offer an intuitive way to display detailed information, allowing users to see and analyze large sets of data in rows and columns. Tables are widely used for both numeric and categorical data representation.

Use Cases for Tables

• Displaying Transactional data

• Detailed sales data for each product, region, or salesperson

Grids Supported in ViewZen Analytics

In ViewZen Analytics, two types of grids are available

• Data Grids - These grids are used to display raw data directly from the dataset. They allow users to view individual records, making them ideal for detailed data analysis. Data grids provide the flexibility to show large volumes of data with the ability to sort and filter through records, providing a clear view of the underlying dataset.

• Aggregate Grids - These grids summarize the data by applying aggregation functions such as sum, average, count, or other calculated metrics. They are designed to offer an overview of the data, showing aggregated insights at a higher level. Aggregate grids are often used for reporting purposes or to identify trends in the data without needing to view every individual record.

Data Properties

The following data properties can be configured for data tables / grids

• Column - The necessary columns for the data grid can be selected and added here.

The following data properties can be configured for aggregate tables / grids

• Dimension - The required grouping columns can be added here.

• Measure - The required measures can be added here.

Format Properties

The following properties can be applied to tables / grids

Property	Remarks
Title	To set a title for the table / grid. E.g., Total Sales, Net Profit etc.
Subtite	To set a subtitle for the table / grid. E.g., Total Sales, Net Profit etc.
Appearance	Used to adjust the appearance and presentation of a table / grid.
Viewer Settings	Tables / grids currently support only the "Full Screen" option.
General Settings	General settings enable you to view and modify the position, dimensions, and size of the table / grid.
Color Fomatting	Only conditional formatting can be applied to tables / grids.
Column Formatting	Column formatting allows customization of how data is displayed within a column.
Sorting	To sort the data
Stacked Header	Stacked headers allow grouping multiple columns under a single header.
Footer	For adding a summarised or aggregated footer section
Actions and Events	Actions can be configured for different click events. Tables can also repond to events triggered by other visuals.
Grid Settings	To control the appearance of data on the chart

Tooltip Properties

The following tooltips can be set

• Title Tooltip

• Visual Tooltip