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 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 Data Detail View

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.

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.

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.

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

Straight Line

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 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 Mass Modifier feature enables user to edit large quantities of records at once. User can perform mass modifications for selected records or all records.

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

More Options (
)

Clicking the triple-dot (⋯) icon displays details of the Y-axis, X-axis, and data objects.

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.
Preview Changes
The Preview Changes allows users to view modifications made to a Matrix grid before saving. Users can also revert changes if needed.

Last updated
Was this helpful?