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.

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.

The following properties can be applied to tables / grids

Property
Remarks

To set a title for the table / grid. E.g., Total Sales, Net Profit etc.

To set a subtitle for the table / grid. E.g., Total Sales, Net Profit etc.

Used to adjust the appearance and presentation of a table / grid.

Tables / grids currently support only the "Full Screen" option.

General settings enable you to view and modify the position, dimensions, and size of the table / grid.

Only conditional formatting can be applied to tables / grids.

Column formatting allows customization of how data is displayed within a column.

To sort the data

Stacked headers allow grouping multiple columns under a single header.

For adding a summarised or aggregated footer section

Actions can be configured for different click events. Tables can also repond to events triggered by other visuals.

To control the appearance of data on the chart

The following tooltips can be set

  • Title Tooltip

  • Visual Tooltip

Last updated