Advanced filters: Overview (MAC v.2)

Updated December 10, 2025 20:17

Summary

MindBridge’s advanced filtering allows you to create complex filters to narrow the scope of the data displayed on the Data table dashboard.

By applying different combinations of filter conditions and rules, you can surface subsets of the dataset for specific audit tests, according to your needs and methodology.

With different combinations of accounts, dates, risk scores, and more, you can use your filtered results to create populations and make selections for random and risk stratified sampling.

Learn more about advanced filtering in MindBridge below.

Note: If you have not updated your MindBridge platform with the Q2 2024 release, refer to the article Use the filter builder (MAC v.1) to create filters.

Go to the Data table dashboard

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.
Select View Analysis in line with the desired analysis. You will go to the analysis results.
Go to the Data table tab.

Tip: If you are already in an engagement, open the Analyze menu ( Analyze menu icon ) in the MindBridge sidebar, select the analysis you want to see, then go to the Data table tab.

Advanced filters

Advanced filters are a powerful tool for managing large datasets and extracting meaningful insights. These filters are comprised of conditions and rules that allow you to control what data is displayed within the data table.

Conditions

Conditions determine the facets of the data you want to find, such as accounts, populations, dates, regions, credit or debit values, control point results, risk scores, and more. Conditions use “is” and “is not” statements (sometimes seen as “are” and “are not”) to determine whether to include or exclude various facets from filtered results.

is: Indicates that the filter will look for entries that match the condition. For example, the filter “Account is Assets" would surface entries related to all Asset accounts.
is not: Indicates that the filter will exclude the condition. For example, the filter “Account is not Assets" would surface entries related to all non-Asset accounts.

Note: Conditions are configured to use "is" by default.

Rules

Rules define how different conditions are combined, as well as how rules interact within the context of other rules. As a result, filters may be simple or complex, depending on the number of rules and conditions and whether conditions are meant to be inclusive or exclusive.

AND: Indicates that all conditions within the rule must be met in order to return results. For example, the filter “Account is Liabilities AND Control point is High risk for Cash Expenditure" would surface entries related to all Liability accounts that received a high Cash Expenditure control point score.
OR: Indicates that conditions within the rule are considered individually. For example, the filter “Account is Liabilities OR Control point is High risk for Cash Expenditure" would surface entries that are related to Liability accounts, as well as entries (not related to Liabilities) that received a high Cash Expenditure control point score.

Note: Rules are joined by AND by default.

Tip: Rules that use AND as the joining statement will reduce the number of analysis results, whereas rules that use OR as the joining statement will expand the number of analysis results.

Use natural language to generate filters (LLM-powered filtering)

MindBridge now supports natural-language filter creation within the Advanced Filter Builder. Instead of manually building conditions and rules, you can type a plain-language description of the filter you want (for example, “Show entries over 50,000 posted to revenue accounts in Q3”).

MindBridge automatically generates the corresponding SQL and ShieldQL expressions, which you can review, adjust, or refine before applying the filter.

You can use natural-language generation as a starting point, or continue building filters manually using the steps below.

Create an advanced filter

Create an advanced filter from scratch using a combination of conditions and rules. You can also use saved filters within any advanced filter you create.

Tip: View examples of advanced filters to get an idea of what you can build.

Step 1: Open advanced filtering

If the dashboard is displaying basic filters, select Switch to advanced (located on the right side of the page, below the Actions button).
Select the Filter by… field to go to the advanced filter builder.

Step 2: Add a condition

The filter builder will provide one condition by default, but you can add as many conditions as desired.

Open the Filter by… menu to see the list of available facets, which are grouped conceptually. If you know which facet you want to use, you can enter its name within the field to search for it.

Tip: Searching not only narrows the results, but allows you to bulk-select facets based on your search terms.
Select the facet you want to add. Additional menu options will appear based on your selection. Use these menus to build out the condition.
Optionally, use the is menu to select whether the facet should be included (“is”) or excluded (“is not”) from the results.
Note: Conditions are configured to use "is" by default.
Optionally, use the AND/OR toggle to select how the condition should be joined with other conditions within the rule.
Note: Rules are joined by “AND” by default. If you switch to "OR", the rule will change colour to help you better understand these interactions.

Remove conditions (optional)

To remove an individual condition, select the X icon to the right of the given condition.

To remove an entire rule (including all of its conditions), select the X icon to the right of the given AND/OR toggle.

Step 3: Add additional conditions and determine rules around how they should interact

To add conditions within the same rule

Open the Add to rule menu (located at the top of each rule in the filter on the left side).

Note: Here you have the option to add another condition, a rule, or a previously saved filter. In this example, we will add a condition.
Select Add condition. A new menu will appear below the first condition.
Select the facet you want to add, then use the dynamic menus that appear to build out the condition.
Optionally use the is menu to select whether the facet should be included (“is”) or excluded (“is not”) from the results.

To add a new rule with more conditions

Open the Add to rule menu (located at the top of each rule in the filter on the left side).
Select Rule. A new nested rule will appear beneath the original rule, with a new condition menu.
Use the AND/OR toggle to select how the conditions should be joined within the rule. In this example, toggle this selection to OR. The rule will change colour to help you better understand these interactions.
Open the Filter by... menu within the new rule, select the facet you want to add, then use the dynamic menus that appear to build out the condition.

Note: Advanced filters can be comprised of a maximum of 5 levels of rules.

Step 4: Generate summary statistics (optional)

Summary statistics give you high-level insight into the scope and impact of the given population.

When creating or editing a population, select Generate statistics (located to the right of the Summary statistics header) to see a visual summary of the population.

Totals

Total entries: The total number of entries within the population
Gross activity: The total value of the population
Total debit: The total debit value of the population
Total credit: The total credit value of the population

Use the summary statistics graph

This graph is generated based on the rules and conditions applied to the given population.

Change the time interval

By default, the graph displays the data in monthly intervals. To change this, open the menu (located above the graph on the right) and choose to view by Month, Week, or Day.

Change the time window

By default, the graph displays data from all dates within the current period. To narrow the scope of the graph, click and drag the time slider (located below the graph) to the desired range.

Step 5: Finalize the filter

When you are satisfied, select Apply (located at the bottom-right corner of the page). The filter will be applied to the dashboard. Optionally, you can also save the filter to use it in the future or share it with your team.

Select Cancel anytime to discard the filter and go back to the Data table dashboard.

Example of a simple advanced filter

Simple filters combine conditions and rules to narrow the scope of results on the data table.

In this example, the company Highland Wilding Tech wants to review some of their cash-based sales transactions in order to ensure their records align with their expectations. To do so, they build a filter to find transactions that credit the account Trade sales of goods/services/resources AND debit the account Cash and cash equivalents.

The structure of this filter would look like:

Increasing credits are in Trade sales of goods/services/resources AND Increasing debits are in Cash and cash equivalents

Example of a complex advanced filter

Complex filters use bracketed expressions to group conditions by order of evaluation, and create more specific and powerful filtering rules, which enables precise slicing and dicing of the data.

In this example, the company Highland Wilding Tech wants to find significant transactions that credit Asset accounts AND that have a high control point score for Cash Expenditure OR Cash to Bad Debt Conversion.

The structure of this filter would look like:

Increasing credits are inAssets AND (Scoped accounts are significant AND Control point is High risk for High Monetary Value OR Cash Expenditure)

Edit filters

Once you have applied an advanced filter to the dashboard, you can make changes to it.

Select the edit icon ( Edit icon.svg ), located next to the applied filter. You will be brought to the advanced filter builder, and the applied rules and conditions will be populated based on the applied filter.

Reset filters

To start over, open advanced filtering and select Reset Filter (located at the bottom-left corner of the page) to discard all current rules and conditions.

Note: Once an advanced filter has been applied to the dashboard, you will not be able to switch back to basic filters unless the filter is reset or cleared.

Save advanced filters

You can save advanced filters for personal use, and share them with your team to use as well. Once saved, these filters can then be added to advanced filters, as well as renamed, shared, or deleted.

In the Save filter section of the advanced filter builder, enter a unique name for the filter.
Use the category menu to select the group of filters you want to save this new filter to.
Use the checkboxes to select the save location(s) for the new filter.
- Library: If your user role permits, select this option to share the filter with the given library. Existing engagements using this library will not be affected, but any new engagements using this library will have access to this filter.
- Organization: If your user role permits, select this option to share the filter with the given organization. Engagements within this organization will have immediate access to this filter.
- Engagement: Select this option to share the filter with the given engagement. Analyses within this engagement will have immediate access to this filter.
- *Private: Your own filters, saved for personal use. These filters will be immediately accessible to you in any engagement you belong to within the given organization.
When you are satisfied, select Save to save the filter to your desired location(s).

*Note: If the filter contains a population, it can only be saved to the engagement or for private use. Additionally, if a population is deleted, any filters that use that population will also be deleted.

User role limitations

App Admins can save filters to a library or to an organization.
Organization Creators can save filters to an organization.
Auditors can save filters for their own personal use and to engagements they belong to within a given organization.

Note: No matter your role, you can use any of the filters that have been saved to the library, organization, or engagement (to which the analysis belongs).

Add a saved filter to advanced filtering

One or more saved filters can be added to advanced filters.

Within the advanced filter builder, open the Add to rule menu (located at the top of the filter).
Select Add saved filter. A window will appear with all of the saved filters you have access to.
Use the tabs on the left side of the window to select the location of the filter you want to use.
- Library: Allows you to access filters saved to the library.
- Organization: Allows you to access filters saved to the organization.
- Engagement: Allows you to access filters saved to the engagement.
- Private: Allows you to access filters created by you.
Select the filter you want to use.

Tip: You can use the chevron icon ( ) to expand the details of each filter to see the rules and conditions that were applied.
When you are satisfied, select Add to apply the saved filter to the advanced filter builder.

Select Cancel anytime to go back without selecting a saved filter.

Rename, share, and delete saved filters

You can perform any of these actions on your saved filters.

Within the advanced filter builder, open the Add to rule menu (located at the top of the filter).
Select Saved filter. A window will appear with all of the saved filters you have access to.
Use the tabs on the left side of the window to select the location of the filter you want to action on.
Open the more actions menu ( ) in line with the filter you want to action on.
Follow the steps in each respective section below to rename, share, or delete a saved filter.

Rename a saved filter

You can rename any saved filter that you have access to.

Select Rename. A form window will appear.
Enter a unique name for the new filter.
Use the category menu to select the group of filters you want to save this new filter to.
When you are satisfied, select Save to save your changes.

Select Back any time to go back to the Add saved filter window.

Select Cancel any time to go back to the Data table dashboard without renaming the filter.

Share a saved filter

You can share a saved filter with your team after it has been created.

Select Share. A form window will appear.
Optionally, update the name of the filter with a new unique name.
Optionally, update the category that the filter should belong to.
Use the checkboxes to select the save location(s) for the new filter.

Note: Filters that contain populations can only be shared with the engagement.
When you are satisfied, select Share to share the filter with the selected location(s).

Select Back any time to go back to the Add saved filter window.

Select Cancel any time to go back to the Data table dashboard without sharing the filter.

Delete a saved filter

You can delete any saved filter that you have access to.

Select Delete. A confirmation window appears.
To permanently delete the filter, select Delete.

Select Cancel any time to go back to the Data table dashboard without deleting the filter.

Note: Deleting populations also deletes associated filters.

Anything else on your mind? Chat with us or submit a request for further assistance.

Questions? We have answers.

Advanced filters: Overview (MAC v.2)

Summary

Go to the Data table dashboard