BI Tool Matrix Settings

 

Matrix Settings is accessed by choosing Matrix as the Component on the Properties screen (also reference under Components. Matrix summarizes detailed data, such as transactions into grouping along the rows and columns. Clicking on a value in the matrix will display all the transactions and data that make up the value. See BI Tool Matrix for more information.

 

When selecting a Matrix, set the Static Fields (which are row labels), Pivot Field (which is a column label) and the Value Field (the value summarized in each cell.) 

 

Graphical user interface, application, email

Description automatically generated

Figure 76: Matrix Settings screen

 

The Matrix Settings screen is accessed by choosing Matrix under Components on the Properties screen, which then prompts the availability of the Matrix Settings button.

 

Graphical user interface

Description automatically generated

Figure 77: Matrix Settings button

 

On the Matrix Settings screen, there are three tabs: Settings, Column Properties, and Calculations.

 

Graphical user interface, application

Description automatically generated

Figure 78: Settings tab on the Matrix Settings screen

 

Details to note on this tab are:

 

Icon / Field

Description

This will save the report/dashboard.

Click to exit out of the Dashboard/Reports Edit screen without saving any of the changes made. This is useful if the user would like to try different Component settings but not save them.

Title:

Description will be used for title of this component in the report/dashboard

Settings tab

Static Field(s):

The fields set will be the row titles in the report. If more than one is needed, click on a title which will add it. Click on the gray area to  prompt the list to show again and click on another title to choose that one, too. The options available in the dropdown are determined by the parameters set under BI Tool Configuration/Data Sources.

Pivot Field:

The field set will be the column titles in the report

 

NOTE: If you choose a date column as the Pivot Field, then you can choose Auto / Year / Quarter / Month in Granularity By.

Value Field

This is the value summarized in each cell

Granularity By:

Aging will allow the user to set Boundaries that will act as columns for the report

Summarize By:

The option Summarize by will add an extra column at the end of report and calculate the Average or Sum of each column.

      Show Matrix as Percentage

If Show Matrix as Percentage is selected, then the totals will be shown as percentages of a line total.

Format

Choose the numerical format that will be used in the report

Column Properties tab

The Columns Properties tab is where you select the fields that are visible and change the order of the fields in the report. The columns are dynamic based on the data source filters.  Click on the Filter to set parameters and further refine the data.

Calculations tab

The Calculations tab is where you can create calculations specific to this matrix. The functionality is the same as the Calculations options available for Main on the Data Sources screen. See BI Tool Configuration/Data Sources and the BI Tool Calculations section within that topic to find more details on how to use this functionality.

Summarize By tab

See BI Tool Columns Grouping Sorting and Summarize By for details on this feature.