Matrix Table
Also known as a Pivot Table
A Matrix Table is a data visualization tool that allows you to display information across multiple dimensions. Unlike regular Data Tables, which present data in flat rows and columns, a Matrix Table enables the arrangement of dimensions along both rows and columns, with measures placed at their intersections. This creates a grid-like layout where each cell shows an aggregated value based on the combination of row and column dimensions.
Components of the View Matrix Table Interface
Title: The name of the Matrix Table.
Columns: Dimensions and/or measures displayed horizontally.
Rows (Data rows): Dimensions displayed vertically, with support for hierarchical expand/collapse functionality.
Totals: Aggregated values displayed at the bottom of columns and at the end of rows.
Row Pagination: Splits the vertical data when there are too many rows to display at once.
Column Pagination: Splits horizontal data when there are many columns or measures.
Functions in the View Matrix Table
Expand/Collapse Rows: Allows you to explore data at different levels of hierarchy for a more detailed or summarized view.
Vertical Paging: Navigate through multiple row groups when the table contains a large dataset.
Horizontal Paging: Navigate through column groups when many dimensions or measures are displayed.
Sort Axis: Sort the table based on the values of any row dimension or measure:
Ascending: From smallest to largest (e.g., A–Z, 1–100, oldest to newest).
Descending: From largest to smallest (e.g., Z–A, 100–1, newest to oldest).
Refresh: Reloads data from the source to reflect the most up-to-date values.
Hard Refresh: Performs a full data reload by bypassing any cached data, ensuring everything is retrieved fresh from the original source.
Export File: Allows users to download the current data in
.xlsxformat. The system supports exporting up to 50,000 rows per file.
Click the menu icon in the top-left corner of the table to access additional supported functions.
Last updated
Was this helpful?