Learn how to add a column that can be used for filtering throughout MindBridge.
Go to the Data page
- Select the logo in the MindBridge sidebar.
You will go to the Organizations page.
- Select View in line with the desired organization, or click anywhere in the organization row.
You will go to the Engagements page.
- Select View in line with the desired engagement, or click anywhere in the engagement row.
You will go to the Data page for that particular engagement.
Add columns for filtering
During column mapping, use the ellipsis to the right of the desired column and select Add column for filtering.
A pop-up window appears.
- You have the option to change the name using the Header Name field.
You will see a preview of the first 2 cells in the selected column.
When you are satisfied, Save your work.
The column will be marked for filtering and you will be taken back to column mapping. Columns marked for filtering are displayed in the bottom right of this page.
When you add columns for filtering, you will also enable a section on the Data page to Import Additional Data.
Where will columns for filtering appear?
Risk overview dashboard
Added columns appear as filters on the Risk overview dashboard and in the Risk by graph.
In general ledger analyses, any columns added for filtering appear in the menus above the graph.
Data table dashboard
Added columns appear as filters in the filter builder on the data table, as well as sortable columns.
Audit assertion risk dashboard
In general ledger analyses, any columns added for filtering appear in the menus above the table.
Filtering is designed for categorical columns, and as a result the number of unique entries in the column should be under 10,000.
Anything else on your mind?