Data Table

General Data View

The View Data Table interface allows users to view raw or transformed data in a tabular format. This is a key feature for checking, validating, and analyzing data in detail.

Components of the View Data Table Interface

1. Title: Name of the Data Table.

2. Header (Data Columns): Names of data fields (dimensions and measures).

3. Rows (Data Records): Each row represents an individual record.

4. Pagination: Splits the data into pages for easier browsing and management.

5. Total Bar: Displays the total values of measures at the bottom of the table. When hovering over the total bar, the system will show the number of currently displayed records / total number of records in the dataset.

Functions in the View Data Table

• Change Column Width: Hover over the right edge of a column header. When the cursor changes to a ↔ (double-headed arrow), click and drag to adjust the column width.

• Data Page Navigation: For paginated Data Table, users can navigate through pages using buttons or by entering a page number manually.

• Infinite Scroll (Auto Load More): When scrolling to the bottom of the table, the system will automatically load more data. Data is loaded in batches of 1,000 rows by default.

• Sort Data (Sort Axis): Allows sorting by any column in either direction:

  • Ascending: A–Z, 1–100, oldest to newest

  • Descending: Z–A, 100–1, newest to oldest

• Refresh: Reloads the displayed data from the source to ensure the most up-to-date information.

• Hard Refresh: A deeper refresh that bypasses the cache and forces a complete reload from the data source.

• Export File: Allows downloading the currently displayed data to an .xlsx file. Up to 50,000 rows can be exported per file.

• Drill Through: Enables users to explore detailed data by clicking on a specific row or value. Upon drilling through:

  • The system navigates to another report page.

  • The selected row's value is automatically applied as a filter for charts on the destination page.