Pivot Grid

The Pivot Grid, also known as a Pivot Table, is a powerful data summarization tool used in data visualization and reporting. It allows users to select and reorganize columns and rows of a dataset or spreadsheet to generate cross-tabular reports.

A pivot grid does not alter the underlying database or spreadsheet. Instead, it provides a flexible way to analyze multi-dimensional data from different perspectives.

Best Situations to Use Pivot Grid

Use a Pivot Grid when you need to:

• Perform multi-dimensional analysis on large datasets.

• Generate cross-tabular reports with grouped or aggregated values.

• Quickly pivot data dimensions (e.g., switch rows to columns).

• Explore data interactively without modifying the source dataset.

• Analyze metrics by categories (e.g., Revenue by Country and City).

Properties of the Pivot Grid

General

• Component Name: Unique identifier for the component.

• Left / Top: Defines horizontal and vertical placement on the canvas.

• Height / Width: Sets the dimensions of the pivot grid.

• Initial Visibility: Controls whether the grid is visible at load.

• Max Button: Enable or disable full-screen mode.

• First Column Width: Define the width of the first column.

• Fit Columns: Auto-fit column widths to content.

Background

• Gradient / Gradient Rotation / Opacity: Customize background appearance.

• Border / Border Color / Border Radius: Define border styling and rounded corners.

• Shadow / Shadow Color / Shadow Transparency: Apply 3D-like depth effects.

💡 Tip: Use subtle gradients and shadows for better readability in large pivot tables.

Title

• Show Title, Title Box, Title Box Color: Manage visibility and background.

• Title Bar Height: Adjust the title bar.

• Description: Add context or supporting text.

• Font (Color, Size, Style, Weight, Family): Customize title typography.

• Align / Text Decoration: Control formatting and alignment.

• Show Dataset Description: Display dataset details in the title.

Subtitle

• Show Sub Title: Toggle subtitle visibility.

• Description: Add supporting descriptive text.

• Font (Color, Size, Style, Weight, Family): Customize subtitle typography.

• Align / Text Decoration: Configure alignment and emphasis.

Header Style

• Header Text Color / Background Color: Style header cells.

• Font (Size, Style, Weight, Family): Customize header text.

• Use Field Color: Apply column-specific colors.

• Text Decoration: Add underline or formatting.

Row Style

• Font (Color, Size, Weight, Family): Customize row text.

• Row Height: Adjust for content visibility.

• Text Decoration: Apply underline or styling.

Styles

• Roll Over Color: Highlight row on hover.

• Text Hover Color: Change text color when hovered.

• Selection Color: Highlight selected cells or rows.

• Horizontal Grid Lines / Vertical Grid Lines: Enable and customize.

• Grid Colors: Set alternating row colors for readability.

Export Options

• Enable Context Menu: Right-click menu for export.

• Supported Formats: Excel (.xlsx), CSV (.csv), JPEG (.jpg), PNG (.png), PPT (.pptx), PDF (.pdf).

• Show Print: Enable direct print.

• Export File Name / Heading / Sub Heading: Customize exported reports.

• Global Export Type: Define default export format (Screenshot, Tabular).

Dataset Properties

• Mapping Rows, Columns, and Values: Example configuration:

  • Row: State, City

  • Column: Country

  • Values: Population, Revenue

• Value Properties: Configure numerical fields (e.g., sum, avg, count) in the Properties panel.

Advanced Usage

• Pivot Grid Variants Different variants can be created by changing the row, column, and value mappings.

• Alerts in Pivot Grids Refer to the Alerts in Grids configuration guide to insert alerts.

• Dataset Configuration Ensure Column Type is set to Numeric for values responsive to Indicator tab settings.