Matrix Runtime

Matrix Runtime

Once the matrix is configured, users can view and edit data in a grid-like interface that supports dynamic measures, conditions, and mass modifications. Standard users can interact with the runtime grid, making edits based on the predefined settings applied during configuration.

To run the configured Matrix, click the Run button, select the desired record, and the Matrix will display data based on the applied configuration.

Matrix Runtime

Matrix Rendering Limits

To ensure smooth performance and a better user experience, Wave enforces rendering limits on the number of records displayed in the Matrix view.

Single Object Matrix Limits

  • Y-axis (row) max limit: 300,000 records

  • X-axis max limit: 120 columns

Two & Three Object Matrix Limits

  • Y-axis (row) max limit: 20,000 records

  • Data records max limit: 300,000

  • X-axis max limit: 120 columns

If your selected data exceeds these limits, a popup message will appear. After clicking OK, you’ll be redirected to the record selection screen to adjust your selection accordingly.

These limits help maintain optimal performance, especially when working with large datasets.

Edit Records in Runtime

After configuring the matrix, users can view and edit data in a grid-like interface. The editing mode is determined in Matrix Designer. Users can edit in Both (DDV and Inline), DDV only, or Inline only, based on the designer's settings.

Edit in Matrix Detail View

Edit in Data Detail View

Edit in Inline

Edit in Inline

Matrix Runtime Features

The Matrix Runtime mode includes several key features: Recent, Dynamic Measure, Timeline, Condition, and Mass Modifier. Each is explained below:

Recent

Displays the most recently run matrices for quick access, which also appears on the Matrix home screen in the Matrix cards.

Recent Runtime

Run Matrix

Use the Run Matrix button in Runtime Mode to execute the Matrix without returning to the dashboard. The Matrix will run based on the current data and configuration.

Run Matrix

To refresh the screen, click on the Refresh icon. Note: Any unsaved data will be lost when refreshing.

Refresh Matrix

Dynamic Measures

This dropdown displays data object fields. Users can view all fields simultaneously or one at a time. Fields appear horizontally or vertically, depending on the orientation set by the designer.

Dynamic Measures

Timeline

Visible when a Date field is set on the X-axis. Users can zoom in and out from years to quarters to months for telescoping or view time intervals in a straight line format. This helps with data forecasting. This must be configured in Matrix Designer.

Telescoping

Timeline - Telescope

Straight Line

Timeline - Straight line

The Condition feature enhances record visibility by allowing users to highlight specific records or groups based on defined conditions. Users can apply background colors to these records, making it easier to identify key data points. This functionality is also known as Conditional Formatting.

The Column Grouping tab allows Designers to visually organize Y-axis fields into grouped sections. This helps users quickly understand how related data points are structured within the Matrix.

The Mass Modifier feature enables user to edit large quantities of records at once. User can perform mass modifications for selected records or all records.

Mass modifier in Matrix

The Sort feature improves data analysis by allowing users to organize records based on one or more fields. Users can sort records in ascending or descending order, helping them focus on the most relevant data first. Sorting applies to any data set displayed in the grid, enhancing usability and clarity during review or decision-making.

The Layout tab lets Designers customize the Matrix's appearance by adjusting row height and enabling auto-sizing for columns. These controls ensure better readability and a polished look for large or dense datasets.

More Options ()

Clicking the triple-dot (⋯) icon in the Matrix runtime toolbar opens the More Options menu, which provides access to:

  • View Details – Displays information about the Y-axis, X-axis, and Data Objects.

  • Reset Matrix – Appears only when changes have been made to the Matrix grid. Clicking this restores the grid to its original default state by clearing personal customizations.

More options

Preview Changes

The Preview Changes allows users to view modifications made to a Matrix grid before saving. Users can also revert changes if needed.

Preview Changes

The Matrix feature helps users analyze Salesforce data by organizing it into rows, columns, and data objects. Users can create, configure, and run matrices to gain insights.

  • Matrix Home Screen: Search, create, and access recent matrices.

  • Matrix Designer: Set up the matrix layout, data settings, timeline, and filters.

  • Matrix Runtime: View and edit data, apply conditions, use dynamic measures, and modify records.

Matrix provides an interactive way to explore and manage data efficiently.

Last updated

Was this helpful?