Showing matrix values in an aggregated form
You can show the matrix values of Visum matrices in an aggregated form. Here, rows and/or columns are summed up according to certain criteria. Thereby the data is displayed differently, but it is not changed.
Notes: You can aggregate external matrices permanently (Aggregating or deleting matrix columns and rows). If you aggregate a filtered matrix, only the filtered values are aggregated. |
1. Open a Matrix editor window with the matrix of your choice (Opening matrices).
2. In the Matrix editor window, on the toolbar, click the button View options.
The View options of Matrix editor window opens.
Tip: Alternatively, from the Matrix editor menu, select View options. |
3. In the Mode section, choose the view whose settings you want to change.
Section |
Description |
Matrix view |
Select this option to make the settings effective in the Matrix view. |
List view |
Select this option to make the settings effective in the List view (Opening matrices in the List view). |
4. In the Dynamic aggregation section, make the settings of your choice.
Section |
Description |
Do not aggregate |
The matrix is not shown in an aggregated from. |
Aggregate rows and columns identically |
The (main) zones of the matrix are aggregated. Thereby the (main) zones are aggregated that have the same attribute values for the attribute selected. Attribute (Main) zone attribute by which the zones are aggregated Note In the List view, for this aggregation with an active OD or matrix value filter, a view might be created that is not defined by any matrix. |
Aggregate rows and columns non-identically |
Rows and/or columns of the matrix are aggregated. Thereby the rows and/or columns are aggregated whose (main) zones have the same attribute values for the attribute selected. Rows (Main) zone attribute by which the rows are aggregated Columns (Main) zone attribute by which the columns are aggregated Notes For instance, if you only want to aggregate rows, use the (main) zone number as attribute for the columns. If you aggregate the data by an indirect attribute, you need to refresh the matrix data after changing it. To do so, click the Recalculate dynamically aggregated view icon, or from the Matrix editor menu, choose > Recalculate dynamically aggregated view. |
Function |
Computation function for aggregating matrix values Minimum The displayed value is the lowest of the aggregated matrix values. Maximum The displayed value is the highest of the aggregated matrix values. Average The displayed value is the average of the aggregated matrix values. Sum The displayed value is the total of the aggregated matrix values. Weighted mean The displayed value is a mean value of the aggregated matrix values, with the matrix values weighted by an OD pair attribute. |
Weighting attribute |
This button is only enabled if the option Weighted mean has been selected in the Function section. Select the (main) OD pair attribute for weighting the values to be regarded for the calculation. |
5. Confirm with OK.
Note: If you filter the matrix data, then the hidden data is not aggregated. |
The aggregated matrix values are shown in the Matrix editor window. An additional row and column show the attribute used for aggregation and the corresponding attribute values.
Notes: You can not edit matrix values in the aggregated view. For dynamically aggregated matrices, you can save the rows and values currently displayed (Saving partial matrices). |