Using Calculated Fields in a Report Matrix
  • Updated on 10 Oct 2013
  • 2 minutes to read
  • Print
  • Dark
    Light

Using Calculated Fields in a Report Matrix

  • Print
  • Dark
    Light

Calculated Fields transform the values of other fields to create entirely new values.  Report Matrices display a count of how many records match each value reported in a column or calculated column.  Each column is referred to as a dimension.  Multiple dimensions can be compared along the x and y axes of the report matrix.
To use calculated fields in a report matrix, create the calculated field in the Report Designer , select the Matrix option, and add the calculated column as a dimension to the x or y axis.
Example
The goal of this example is to:

  1. Create a report with a calculated column.

  2. Add a matrix to the report that uses the calculated column as a dimension.

  3. Run the report to view the matrix.

To begin, navigate to a Design Folder .  Select the button Create Report .
2018-03-26_155436-5.png

In the resulting New Report window, give the new report a name and click Ok .
2018-01-02_124831.png

Next, define the data source for the report by selecting the Add Button in the Folder Data Source to the Source list from the Data Sources > Common Data Source category in the Pop Up.
2018-01-02_124851.png

Next, add the Respect Permission Filter to the Filters section by selecting the Add Button in the Filers Field
2018-01-02_125023.png

Now,  select the Add Button in the Data Field field andselect the columns Entity Name , Folder Type Name , andNesting Level.
2018-01-02_125110.png

Expand the Calculated Columns category and drag the TruncateTextInlineField option into the workspace.
2018-01-02_125248.png

In the resulting Add Calculated Column pop-up window, configure the calculated column.  This column will display the truncated value of another column.  For this example, configure the column to display the first three letters of the Folder Type Name column.  Select Folder Type Name in the Field drop down list and type “3” in the Limit field.  Click Ok to finish the calculated column.
2018-01-02_125358.png

The new calculated column, truncate_text_inline_field , appears in the workspace.
2018-01-02_125510.png

To add a Matrix option to the menu bar, click on Add in the Views section, then select Matrix
2018-01-02_125605.png

This will add a Matrix option to the view menu bar.  This Matrix view will automatically open.
To build the report matrix, select the Matrix option.  Select the Add Dimension link corresponding to the y-axis and select Add Field Dimension .
2018-01-02_125817.png

In the Edit pop-up, select Folder Type Name in the Field drop down list and click Ok .
2018-01-02_130037.png

To add a second dimension, in theEdit pop-up window, select truncate_text_inline_field in the Field drop down list and click Ok .
2018-01-02_130152.png

To add a third dimension, select the Add Dimension link corresponding to the x-axis and select Add Field Dimension .
2018-01-02_130638.png

In the Edit pop-up window, select Nesting Level in the Field drop down list and click Ok .
2018-01-02_130917.png

The final product should look like this.  Now, save the report and close the Report Designer
2018-01-02_131005.png

Back in the portal, select the report and in its Action menu, select Run Report .
2018-01-02_131320.png

The report will appear in a new window.  All of the columns, including the calculated column, will be displayed under the Data icon.
2018-01-02_131530.png

Select the Matrix icon to see the report matrix.
2018-01-02_131637.png

Was this article helpful?