Skip to content

Filter and Sort Anomalies

Search, filter, and sort the anomaly list to find the anomalies you need to review or act on.

The list appears on Explore > Anomalies, and on the Anomalies tab of a datastore, a table or file, a field, a check, or a check template. The Search field, the Filter menu, and the sort menu sit in a row above the list. To switch between ascending and descending order, click the arrow to the left of the selected sort criterion. To switch between open and archived anomalies, use the status tabs above the list, described in Status below.

The Search field finds anomalies by identifier or description.

Status

The status tabs above the list split it in two: Open for the anomalies that still need attention, and Archived for the ones that have been closed. Each tab has subtabs, one per status. The tabs work the same on every anomaly list. For what each status means, see Anomaly Status.

Steps

Step 1: Open the Anomalies tab of a datastore, a table or file, a field, a check, or a check template, or go to Explore › Anomalies. The list opens on the Open tab, on its Active subtab, or on All when no anomaly is active.

Step 2: Click Open or Archived . The subtabs of that group appear below it.

Step 3: Click the subtab you want. The list shows only the anomalies with that status, and the search, filters, and sort apply within it.

Tab Subtab Shows
Open Active Anomalies nobody has acknowledged or archived yet.
Open Acknowledged Anomalies someone has reviewed that still need work.
Open Assigned Open anomalies where you are an assignee.
Open All Every open anomaly, Active and Acknowledged.
Archived Resolved Real issues that have been fixed.
Archived Duplicate Anomalies that repeat another one.
Archived Invalid Anomalies that were not real data quality issues.
Archived Discarded Anomalies that are no longer relevant.
Archived All Every archived anomaly.

Bulk actions follow the tab

The selection bar offers the actions that fit the tab: Acknowledge on Active, Reactivate on Acknowledged, Archive on open anomalies, and Delete on archived ones. See Acknowledge Anomalies.

Filters

The Filter menu narrows the list by the conditions below. Pick a filter on the left side of the menu, choose its value on the right, and click Apply. Clear at the top of a filter's options resets that filter. Clear all at the top of the menu resets every filter at once.

Next to the filter's name, at the top of its options, a drop-down sets how the selected values match. It lists only the operators that filter supports, and starts on the first operator in its list.

Operator Shows
is any of The items that match at least one selected value.
is not any of The items that match none of the selected values.
is all of The items that match every selected value, such as the items that carry all of the selected tags.
is empty / is not empty is empty shows the items with nothing set for that filter, such as no tag. is not empty shows the items with something set.
is / is not The items that match the selected value, or the items that don't, for filters where you pick one value.

The menu offers only the filters that make sense where you opened the list, so a list that is already scoped to one table does not offer a table filter. Pick the tab below for the place you opened the list from.

Open Explore > Anomalies. The list covers every datastore you can access. To narrow it by datastore or tag, use the Source Datastores and Tags selectors at the top of the Explore page. The Filter menu offers the rest.

Filter Description
Timeframe Shows only the anomalies detected in the selected period: Week, Month, 6 Months, or 365 Days.
Type Shows only Record anomalies or only Shape anomalies.
Impact Shows only the anomalies at the selected impact levels: Critical, High, Medium, or Low. Choose is not any of to hide those levels instead.
Rule Shows only the anomalies raised by checks of the selected rule types.
Assignee Shows only the anomalies assigned to at least one of the selected users. Use the search box inside the menu to find a user by name, username, or email. Not offered on the Assigned subtab, which already shows only the anomalies assigned to you.

Open a datastore and select its Anomalies tab. The list is already scoped to that datastore.

Filter Description
Timeframe Shows only the anomalies detected in the selected period: Week, Month, 6 Months, or 365 Days.
Type Shows only Record anomalies or only Shape anomalies.
Impact Shows only the anomalies at the selected impact levels: Critical, High, Medium, or Low. Choose is not any of to hide those levels instead.
Rule Shows only the anomalies raised by checks of the selected rule types.
Tags Shows only the anomalies that carry at least one of the selected tags.
Table or File Shows only the anomalies of the selected table or file. The filter is named Table or File to match the kind of datastore.
Field Shows only the anomalies of the selected fields. Choose is empty in the drop-down to show the anomalies whose checks are not tied to a field. Pick a table or file first. Until then, the filter asks you to pick one.
Quality Check Shows only the anomalies raised by the selected checks. The list offers only checks that have anomalies. Pick a table or file first. Until then, the filter asks you to pick one.
Assignee Shows only the anomalies assigned to at least one of the selected users. Use the search box inside the menu to find a user by name, username, or email. Not offered on the Assigned subtab, which already shows only the anomalies assigned to you.

Open a table or file and select its Anomalies tab. The list is already scoped to that table or file.

Filter Description
Timeframe Shows only the anomalies detected in the selected period: Week, Month, 6 Months, or 365 Days.
Type Shows only Record anomalies or only Shape anomalies.
Impact Shows only the anomalies at the selected impact levels: Critical, High, Medium, or Low. Choose is not any of to hide those levels instead.
Rule Shows only the anomalies raised by checks of the selected rule types.
Tags Shows only the anomalies that carry at least one of the selected tags.
Field Shows only the anomalies of the selected fields. Choose is empty in the drop-down to show the anomalies whose checks are not tied to a field.
Quality Check Shows only the anomalies raised by the selected checks. The list offers only checks that have anomalies.
Assignee Shows only the anomalies assigned to at least one of the selected users. Use the search box inside the menu to find a user by name, username, or email. Not offered on the Assigned subtab, which already shows only the anomalies assigned to you.

Open a field and select its Anomalies tab. The list is already scoped to that field.

Filter Description
Timeframe Shows only the anomalies detected in the selected period: Week, Month, 6 Months, or 365 Days.
Type Shows only Record anomalies or only Shape anomalies.
Impact Shows only the anomalies at the selected impact levels: Critical, High, Medium, or Low. Choose is not any of to hide those levels instead.
Rule Shows only the anomalies raised by checks of the selected rule types.
Tags Shows only the anomalies that carry at least one of the selected tags.
Quality Check Shows only the anomalies raised by the selected checks. The list offers only checks that have anomalies.
Assignee Shows only the anomalies assigned to at least one of the selected users. Use the search box inside the menu to find a user by name, username, or email. Not offered on the Assigned subtab, which already shows only the anomalies assigned to you.

Open a check and select its Anomalies tab. The list is already scoped to the anomalies that check raised.

Filter Description
Timeframe Shows only the anomalies detected in the selected period: Week, Month, 6 Months, or 365 Days.
Type Shows only Record anomalies or only Shape anomalies.
Impact Shows only the anomalies at the selected impact levels: Critical, High, Medium, or Low. Choose is not any of to hide those levels instead.
Rule Shows only the anomalies raised by checks of the selected rule types.
Assignee Shows only the anomalies assigned to at least one of the selected users. Use the search box inside the menu to find a user by name, username, or email. Not offered on the Assigned subtab, which already shows only the anomalies assigned to you.

Open a check template and select its Anomalies tab. The list covers the anomalies raised by every check created from that template, across datastores.

Filter Description
Timeframe Shows only the anomalies detected in the selected period: Week, Month, 6 Months, or 365 Days.
Type Shows only Record anomalies or only Shape anomalies.
Impact Shows only the anomalies at the selected impact levels: Critical, High, Medium, or Low. Choose is not any of to hide those levels instead.
Rule Shows only the anomalies raised by checks of the selected rule types.
Tags Shows only the anomalies that carry at least one of the selected tags.
Datastore Shows only the anomalies of the selected datastore.
Container Shows only the anomalies of the selected table or file. Pick a datastore first. The filter is then renamed Table or File to match the kind of datastore.
Field Shows only the anomalies of the selected fields. Choose is empty in the drop-down to show the anomalies whose checks are not tied to a field. Pick a table or file first. Until then, the filter asks you to pick one.
Assignee Shows only the anomalies assigned to at least one of the selected users. Use the search box inside the menu to find a user by name, username, or email. Not offered on the Assigned subtab, which already shows only the anomalies assigned to you.

Sort

The sort menu is the same wherever you open the list. It orders the list by one of the following criteria. Select a criterion, then pick its direction on the same row. The list reorders when the menu closes.

Sort Description
Anomalous Records Orders the list by how many records each anomaly affects, Most or Fewest first. Anomalies without a record count appear at the bottom of the list in both directions.
Created Date Orders the list by when each anomaly was detected, Newest or Oldest first.
Impact Orders the list by the impact level of each anomaly, Highest or Lowest first. This is the default order. See how Impact is decided.