# 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.

> **Note:**\
> Matrix Runtime is available in **both** Wave Extension and Wave Embedded.

* In **Wave Embedded**, click **Save and Surf**. This opens a temporary **Surf the Matrix** tab where you can view and interact with the runtime grid.<br>

  <figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FiBs36St9EcE5Lho0ePk6%2FWave%20Embedded%20-%20Matrix%20Runtime.gif?alt=media&#x26;token=05747200-ee61-4cec-9e23-f7fd1959f302" alt=""><figcaption><p>Surf The Matrix - Wave Embedded</p></figcaption></figure>

* In **Wave Browser Extension**, click the **Run** button, select the desired record, and the matrix will launch in runtime mode displaying data based on your configuration.<br>

  <figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FeEAoCTdibEbvtRkfsbDa%2FWave%20Extension%20-%20Matrix%20Runtime.gif?alt=media&#x26;token=af84d19d-8ec8-4809-a226-c41c5d868bba" alt=""><figcaption><p>Matrix Runtime - Wave Browser Extension</p></figcaption></figure>

Both runtime environments are designed to help users efficiently work with data while adhering to the configuration rules defined during matrix setup.

### 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

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FH99CkwSTktQBXpAVj0lA%2FData%20Detail%20View%20Edit.gif?alt=media&#x26;token=574802fe-283c-4efe-8b8c-3b2c1e84c8d7" alt=""><figcaption><p>Edit in Data Detail View</p></figcaption></figure>

#### Edit in Inline

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2Fse1LKwV4zlHrEnsSqPib%2FInline%20Edit.gif?alt=media&#x26;token=2be32998-c218-431a-9b99-4b170aa05dc4" alt=""><figcaption><p>Edit in Inline</p></figcaption></figure>

## **Matrix Runtime Features**&#x20;

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

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FlKseG7exDCczgUfmdGL6%2FMatrix%20Runtime%20Feature.png?alt=media&#x26;token=694634dc-575c-40da-975f-827645761362" alt=""><figcaption></figcaption></figure>

### Recent

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

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FEPiS9Kk8bwDvuDKcFhg8%2FRecent%20Matrix.gif?alt=media&#x26;token=4139777a-0756-4f57-824d-c243a71dc170" alt=""><figcaption><p>Recent Runtime</p></figcaption></figure>

### **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.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FAeavx9RypiemisEbZIaU%2FRun%20Matrix.gif?alt=media&#x26;token=89cb5d27-6ca2-4c00-a638-3c848ffd0e74" alt=""><figcaption><p>Run Matrix</p></figcaption></figure>

### [Refresh](https://docs.valorx.com/valorx-wave/wave-data-management/managing-grid-data#refresh) ![](https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FKx5OutLpGQkTRxkKAGOl%2FRefresh.png?alt=media\&token=7706472d-71b6-4676-8953-44dc00d84713)&#x20;

To refresh the screen, click on the Refresh icon.\
\&#xNAN;***Note:** Any unsaved data will be lost when refreshing.*

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2Fvxl1psK9lEzcEWiNMpuu%2FRefresh%20Matrix.gif?alt=media&#x26;token=be550aae-f395-463f-9fb8-849260990c59" alt=""><figcaption><p>Refresh Matrix</p></figcaption></figure>

### **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.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FJ2r5AnxsAnk7txH6sIic%2FDynamic%20Measures.gif?alt=media&#x26;token=60a35ed2-22e2-4b84-a9da-a0c0567fddc1" alt=""><figcaption><p>Dynamic Measures</p></figcaption></figure>

### **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](https://docs.valorx.com/valorx-wave/matrix-configuration#id-3.-timeline-matrix-configuration-visible-only-for-date-fields).

#### Telescoping

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FQcSXquEG2Gkyrb4ex2Gs%2FTelescoping%20-%20Timeline.gif?alt=media&#x26;token=a631f011-af8a-4ff9-8eea-42473dab98ab" alt=""><figcaption><p>Timeline - Telescope</p></figcaption></figure>

#### Straight Line

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FtbMXbwtaaDiS2ASlUYkG%2FStraight%20Line%20-%20Timeline.gif?alt=media&#x26;token=069778d1-fa55-478e-ba75-ab28715692bb" alt=""><figcaption><p>Timeline - Straight line</p></figcaption></figure>

### [Condition](https://docs.valorx.com/valorx-wave/wave-data-management/managing-grid-data/condition) ![](https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FClCt5YJ5jXh6Gkuxl8gN%2FCondition.png?alt=media\&token=9883c932-8f09-42a3-8a17-200691c1ec3d)

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**.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2F3EHMiT4cXzrQdSfhiLib%2FMatrix%20Condition%20Applied.gif?alt=media&#x26;token=609dd080-b2b4-4113-8979-08f452c3de1f" alt=""><figcaption></figcaption></figure>

### [Column Group](#column-grou)

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.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FuRjikVDgBnA1Cm3z3ZBN%2FColumn%20Group%20Runtime.gif?alt=media&#x26;token=bdbee6a6-88de-4a20-91c7-feb53695e593" alt=""><figcaption></figcaption></figure>

### [Mass Modifier](https://docs.valorx.com/valorx-wave/wave-data-management/managing-grid-data/mass-modifier) ![](https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FSY4Zk39OAcN7LAHhJvAc%2FMass%20Modification.png?alt=media\&token=6dc99564-00a9-4a19-aa4e-3c411b991ff3)

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.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2Fagqbo91iKhC2AwtKW9Zg%2FMass%20Modifier.gif?alt=media&#x26;token=74d7d716-59ac-4b99-91a7-e377e2b2abf0" alt=""><figcaption><p>Mass modifier in Matrix</p></figcaption></figure>

### [Sort](https://docs.valorx.com/valorx-wave/wave-data-management/managing-grid-data#sort)

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.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FrGYzR8tNRA9KGPBoOd1K%2FSort.gif?alt=media&#x26;token=6b42952c-2b13-4a58-8c09-1a6945a80881" alt=""><figcaption></figcaption></figure>

### [Layout](https://docs.valorx.com/valorx-wave/wave-data-management/managing-grid-data#layout)

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.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FzF3LzDibsMkkeBDVkans%2FLayout.gif?alt=media&#x26;token=9556336b-7a66-4678-9dc0-35a85b284391" alt=""><figcaption></figcaption></figure>

### **More Options (**![](https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FoyzoKnEl7LpF5aE8fs8f%2FHamburger%20Dot.png?alt=media\&token=a4b98c1c-3f84-4733-bdac-652b06a2953b))

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.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FVAIA7kBCIPIRVXpsPOGN%2FView%20Details.png?alt=media&#x26;token=d287bfc8-478b-4dbe-832b-589c18bc027f" alt=""><figcaption></figcaption></figure>

#### **Backup Matrix**

The **Backup Matrix** feature lets you save your Matrix configuration as a backup file, so you can easily restore it later.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2Fxi4awb2WpBzw9ut8pmFQ%2FBackup%20from%20Matrix.gif?alt=media&#x26;token=057e6be1-829d-4e1d-abf8-e53fb9ce4cbd" alt=""><figcaption><p>Backup Matrix</p></figcaption></figure>

#### **Reset Matrix**&#x20;

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.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FDjDqxVYk0gVFyOAU6TIs%2FReset%20Matrix.gif?alt=media&#x26;token=624557e9-e6fc-4ccb-abcb-d7eac4edd68c" alt=""><figcaption><p>Reset Matrix</p></figcaption></figure>

### Preview Changes

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

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FPRsYyNzD1I61PBAQodxy%2FPreview%20Changes.gif?alt=media&#x26;token=25642f7a-da19-49bf-9436-b23a8ca3d67c" alt=""><figcaption><p>Preview Changes</p></figcaption></figure>

The **Matrix** feature helps users analyze Salesforce data by organizing it into rows, columns, and data objects. Matrix provides an interactive way to explore and manage data efficiently.

#### Footer Row in Matrix

The matrix includes a **footer row**, similar to the grid, showing aggregated values for all Y-axis columns, data columns, and the Totals column.

**By default:**

* The aggregation function for Y-axis fields is **Sum**.
* For data columns, the aggregation follows the grouping function configured in **Data Config**.
* Users can change the aggregate function displayed in the footer as needed.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FUqrDKwfAsRr2w4bnHERi%2FFooter%20Row.gif?alt=media&#x26;token=e764c1d9-d803-4422-bdbd-bdd2c6bf8bb9" alt=""><figcaption></figcaption></figure>

***

## Surf The Matrix Tab Visibility in Wave Embedded

In **Wave Embedded**, some users may not see the **Surf the Matrix** tab after running a Matrix. This is due to specific Salesforce **App Personalization Settings** configured in the App Manager. The Matrix itself still renders correctly, and users can access it by clicking **Surf the Matrix** button in **Wave Dashboard** or the **Save and Surf** button in the **Matrix Wizard**.&#x20;

To ensure the **Surf the Matrix** tab appears consistently in Wave Embedded, follow these steps:

1. Go to **Setup** in Salesforce.
2. In the Quick Find box, search for **App Manager**.
3. Under the **App Name** column, locate **Valorx Wave**.
4. Click the **dropdown arrow** next to **Valorx Wave**, then click **Edit**.
5. On **App Settings** page, click on the **App Options**.
6. In the **App Personalization Settings** section, uncheck the following:
   * **Disable end user personalization of nav items in this app**
   * **Disable temporary tabs for items outside this app**
7. Click **Save**.

Once updated, Salesforce will display **Surf the Matrix** as a temporary tab, making it more convenient to revisit or switch between tabs in Wave Embedded.

<figure><img src="https://2237973035-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F65f4C4H8V5e0YV342mwp%2Fuploads%2FcwCeBn5SD7vPwtHW7n2O%2FSurf%20The%20Matrix%20Missing.gif?alt=media&#x26;token=e97a3b77-b521-4cf3-bc47-a69562fc5c03" alt=""><figcaption><p>How to Display <em>Surf the Matrix</em> in the Navigation Bar</p></figcaption></figure>
