Compare data in a matrix
Last updated
Was this helpful?
Last updated
Was this helpful?
The Matrix feature allows you to filter and pivot selected rows of data simultaneously. As a result, you can view data for two dimensions together, which is a great way to make quick comparisons and identify differences. For example, suppose you want to compare the performance of your sales reps side-by-side against the regions where you sell your products.
Select the first dimension you want to matrix (Sales Rep). This is the one that will be transformed into columns in the grid.
Select the rows of the entities you want to matrix (top 5 performing sales reps). As with the Focus button, when you select rows, the Matrix button becomes active in the filter bar.
Click the Matrix button. The other data is filtered out and the grid updates to show the selected rows, which are also transformed into columns. The matrix filter displays as a chip on the right of the filter bar.
Select the second dimension you want to include in the matrix (Region). Its data displays in rows in the grid, so you can see the values against each of the other dimension's entities (sales reps columns).
In the matrix grid, you can continue your analysis.
Focus on specific rows to reduce the dataset in the matrix.
Pivot the matrix (switch the dimensions around). Select the rows then click the Pivot button. The rows are transformed into columns and vice versa.
