> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cortex.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Explorer reference

Filter options vary depending on the metric you're viewing. For example, the **Opened PRs** metric shows version control filters, while **Story points completed** shows project management filters.

For information on selecting a metric, see [Available metrics in Data Explorer](https://docs.cortex.io/improve/eng-intelligence/data-explorer/available-metrics-in-data-explorer.md#accessing-metrics-in-data-explorer).

For information on accessing the filters listed below, refer to [Filtering and grouping metrics](https://docs.cortex.io/improve/eng-intelligence/data-explorer#step-2-filtering-and-grouping-metrics).

## Filter operators and selectors

Some filters support operators and/or selectors. Select an operator/selector from the drop-down menu next to the filter name, then enter a value or values to define the range or condition.

### Numeric operators

Available numeric operators:

* Equals, Does not equal, >, ≥, \<, ≤, Is between, Is empty, Is not empty

Numeric operators are found on the following filters:

* **Version control** - Lines added, Lines deleted, Files changed, Number of comments, Commits, Cycle time, PR size
* **Deployment** - Duration
* **Incident** - Time to resolution
* **Project management** - Story points, Time spent, Original estimate, Remaining estimate, Number of comments

### String operators

Available string operators:

* Is, Is not, Is empty, Is not empty, Contains, Excludes

String operators are found on the following filters:

* **Teams & Users** - Inherited team, User, Team, User label, User label name, Assignee, Assignee team, Assignee user label, Deployer, Incident assignee
* **Entity** - Inherited domain, Inherited team owner, Domain, Entity, Entity type, Group, Entity owner
* **Version control** - Label
* **Deployment** - Environment, Status
* **Project management** - Component, Label, Sprint, Status, Work item type

> [!NOTE]
>
> Because they can never be empty, the following three filters have a slightly reduced set of operators \*\*(\*\*no **Is empty** / **Is not empty**):
>
> * **Version control** - Repository, Status
> * **Project management** - Project
>
> One filter has its own set (**Equals**, **Does not equal**, **Is empty**, **Is not empty**):
>
> * **Version control** - Draft
>
> The **Scorecard** filter also has its own set (**Is**, **Is not**, **Is empty**, **Is not empty**):
>
> * **Scorecard** - Level

### Role selectors

The Author/Reviewer role selector is found on the following filters:

* **Version control** - User, Team, User label, User label name

## Example filter scenarios

Filters are most useful when you combine them to answer a specific question. A few common examples:

**Version control**

* Filter **Cycle time** by **>** 3 days to find PRs that are taking longer than expected to ship. This can help you spot patterns like review bottlenecks.
* Filter **Number of comments** by **Equals** 0 to find PRs that shipped with no review comments, a possible quality or risk signal.
* Filter **PR size** by **>** 1,000 lines, or **Files changed** by **>** 10, to see the cycle time for your largest PRs and understand how PR size affects delivery speed.
* Filter **Draft** by **Equals** true combined with **Cycle time** by **>** 7 days to catch PRs that have been sitting in draft for a long time, work that's stalled before it even reaches review.

**Project management**

* Filter **Story points** by **≥** 8 to surface large work items that may need to be broken down into smaller pieces.
* Filter **Work item type** by **Is** "Bug" combined with **Time spent** by **>** 3 days to see which bugs are consuming the most engineering time.

**Incidents**

* Filter **Time to resolution** by **>** 12 hours to identify incidents where response is breaking down.

**Deployments**

* Filter **Duration** by **>** 30 minutes to spot patterns leading to slow deployments.
* Filter **Environment** by **Is** "Staging" combined with **Status** by **Is not** "Success" to catch deployments failing in staging before they'd ever reach production.

**Teams and users**

* Filter **User label** by **Is** "AI User (last 7 days)" to compare cycle time or PR throughput between people using GitHub Copilot and those who aren't.
* Filter **Team** with the **Reviewer** role selector to see how much review load a team is carrying across the org, not just on their own PRs.

**Entity**

* Filter **Entity type** by **Is** "Service" combined with **Group** by **Is** "Tier 1" to focus metrics on your most critical production services only.

**Scorecards (table view only)**

* Filter **Level** by **Is** "No level" to find entities that haven't reached the first level of a Scorecard yet, a quick way to see where adoption has stalled.
* Filter **Level** by **Is not** "Level 3" alongside **Entity owner** to see which teams still have work left on a migration Scorecard.

## Filter definitions

### Teams and users

The filters in this section focus on scoping data to specific people or teams. Available filters are dependent on the metric being viewed.

| Filter | Definition |
| - | - |
| **Assignee** | View data for work items assigned to a specific user. |
| **Assignee team** | View data for work items assigned to users belonging to a specific team. |
| **Assignee user label** | View data for work items assigned to users with a specific [user label](https://docs.cortex.io/improve/eng-intelligence/eng-intelligence#group-by-user-label). |
| **Deployer** | View data for deployments performed by a specific user. |
| **Group** | View data only for entities associated with a specific [group](https://docs.cortex.io/ingesting-data-into-cortex/entities-overview/entities/groups.md). |
| **Incident assignee** | View data for incidents assigned to a specific user. |
| **Individual owner** | View data for metrics on entities owned by a specific user. For example, if Service X is owned by Marco, filtering by Marco only shows data for Service X even if the work was performed by someone else. |
| **Inherited team** | View data for entities whose team is inherited from a parent entity in the hierarchy. |
| **Team** | View data for a specific team. • For version control metrics, filters by the team of the PR author or reviewer (based on the **Version control team types** setting). • For deployment metrics, filters by the team of the deployer. • For incident metrics, filters by the team of the incident assignee. |
| **Team owner** | View data for metrics on entities owned by a specific team. This only includes entities owned directly by the selected team, not its child teams. To include child teams' entities, use **Entity owner** with **Include child teams** on. |
| **User** | View data authored by a specified user. |
| **User label** | View data authored by users with a specific [user label](https://docs.cortex.io/improve/eng-intelligence/eng-intelligence#group-by-user-label). Cortex automatically creates an AI Usage label for GitHub Copilot usage with values **AI User (last 7 days)** and **Non-AI User (last 7 days)**. |
| **User label name** | View data authored by users with a specific [user label](https://docs.cortex.io/improve/eng-intelligence/eng-intelligence#group-by-user-label) value. |

### Entity

The filters in this section focus on scoping data to specific entities, entity types, or the groups they belong to.

| Filter | Definition |
| - | - |
| **Inherited domain** | View data only for entities whose domain is inherited from a parent entity in the hierarchy. |
| **Inherited team owner** | View data only for entities whose team owner is inherited from a parent entity in the hierarchy. |
| **Domain** | View data only for entities belonging to a specific domain. |
| **Entity** | View data only for a specific entity. |
| **Entity type** | View data only for specific types of entities (such as services or teams). |
| **Group** | View data only for entities associated with a specific [group](https://docs.cortex.io/ingesting-data-into-cortex/entities-overview/entities/groups.md). |
| **Entity owner** | View data only for entities owned by a specific user or team. When you filter by a team, **Include child teams** is on by default, so entities owned by the team's child teams are included. Toggle it off to see only the selected team's entities. |

### **Version control**

The filters in this section are specific to version control metrics and let you scope data by pull request attributes such as status, label, and repository.

| Filter | Definition |
| - | - |
| **Label** | View data only for PRs tagged with a specific label. |
| **Repository** | View data only for a specific repository. |
| **Status** | View data for PRs in specified statuses. |
| **Lines added** | View data for PRs with a specific number of lines added. |
| **Lines deleted** | View data for PRs with a specific number of lines deleted. |
| **Files changed** | View data for PRs with a specific number of files changed. |
| **Number of comments** | View data for PRs with a specific number of comments. |
| **Commits** | View data for PRs with a specific number of commits. |
| **Draft** | View data filtered by whether PRs are drafts or not. |
| **Bot generated** | View data filtered by whether PRs were generated by bots or not. |
| **Cycle time** | View data for PRs within a specific cycle time range. |
| **PR size** | View data for PRs within a specific size range (based on total lines of code modified). |

### **Deployments**

The filters in this section are specific to deployment metrics and let you scope data by attributes such as deployment status and environment.

| Filter | Definition |
| - | - |
| **Environment** | View data only related to a specific environment sent via the [deploys API](https://docs.cortex.io/api/rest/deploys). |
| **Status** | View data for deployments in specified statuses. |
| **Duration** | View data for deployments within a specific duration range. |

### **AI tools**

There are no AI-specific filters. Only **Teams & Users** and **Entity** filters apply to AI tools metrics.

### **Project management**

The filters in this section are specific to project management metrics and let you scope data by work item attributes such as status, type, sprint, and project.

> [!NOTE]
>
> [Unique defaultJQL configurations](https://docs.cortex.io/ingesting-data-into-cortex/integrations/jira.md#set-a-default-jql-query-for-your-jira-integration) per entity aren't supported for filtering or segmenting data in Data Explorer.

| Filter | Definition |
| - | - |
| **Component** | View data only for work items assigned to a specific component. |
| **Label** | View data only for work items tagged with a specific label. |
| **Project** | View data only for work items belonging to a specific project. |
| **Sprint** | View data only for work items assigned to a specific sprint. |
| **Status** | View data for work items in specified statuses. |
| **Work item type** | View data for work items of a specific type. |
| **Story points** | View data for work items with a specific story point value or range. |
| **Time spent** | View data for work items with a specific amount of time logged. |
| **Original estimate** | View data for work items with a specific original time estimate. |
| **Remaining estimate** | View data for work items with a specific remaining time estimate. |
| **Number of comments** | View data for work items with a specific number of comments. |

### **Incidents**

The filters in this section are specific to incident-related metrics.

> [!NOTE]
>
> **Team** and **user** filters are only supported for PagerDuty.

| Filter | Definition |
| - | - |
| **Status** | View data for incidents in specified statuses. |
| **Urgency** | View data for incidents in specified urgencies. |
| **Time to resolution** | View data for incidents within a specific time-to-resolution range. |

### Custom metrics

The filters in this section are specific to the custom metrics you created in Cortex.

| Filter | Definition |
| - | - |
| **Inherited domain** | View data only for entities whose domain is inherited from a parent entity in the hierarchy. |
| **Inherited team owner** | View data only for entities whose team owner is inherited from a parent entity in the hierarchy. |
| **Domain** | View data only for entities belonging to a specific domain. |
| **Entity** | View data only for a specific entity. |
| **Entity type** | View data only for specific types of entities (such as services or teams). |
| **Group** | View data only for entities associated with a specific [group](https://docs.cortex.io/ingesting-data-into-cortex/entities-overview/entities/groups.md). |
| **Entity owner** | View data only for entities owned by a specific user or team. When you filter by a team, **Include child teams** is on by default, so entities owned by the team's child teams are included. Toggle it off to see only the selected team's entities. |

### Scorecard **(table view only)**

The filter in this section applies to table view when a Scorecard column is in the report. Refer to [Scorecards in table view](https://docs.cortex.io/improve/eng-intelligence/data-explorer/available-metrics-in-data-explorer.md#scorecards-table-view-only) for more information.

| Filter | Definition |
| - | - |
| **Level** | View data only for entities at a specific level on the Scorecard's ladder. Levels are listed by position, with the level name in parentheses, such as **Level 1 (Bronze)**. Select **No level** to find entities that haven't reached the first level yet. You can select more than one value. |

## 'Group by' definitions

'Group by' options vary depending on the metric you're viewing. For example, the **Cycle time** metric shows version control group by options, while **Story points completed** shows project management group by options.

For information on selecting a metric, see [Available metrics in Data Explorer](https://docs.cortex.io/improve/eng-intelligence/data-explorer/available-metrics-in-data-explorer.md).

For information on grouping metrics, refer to [Grouping metrics](https://docs.cortex.io/improve/eng-intelligence/data-explorer#grouping-metrics-chart-and-table-views).

### **Teams and users**

The 'group by' options in this section let you segment data by specific people or teams. Available options are dependent on the metric being viewed.

| Group by | Definition |
| - | - |
| **Team** | Group data by team. • For version control metrics, groups by the team of the PR author or reviewer (based on the **Version control team types** setting). • For deployment metrics, groups by the team of the deployer. • For incident metrics, groups by the team of the incident assignee. |
| **User** | Group data by individual user. |
| **User label** | Group data by [user label](https://docs.cortex.io/improve/eng-intelligence/eng-intelligence#group-by-user-label). |

### **Entity**

The 'group by' options in this section let you segment data by entity-related attributes such as entity type, domain, or group.

| Group by | Definition |
| - | - |
| **Entity** | Group data by individual entity. |
| **Group** | Group data by the [group](https://docs.cortex.io/ingesting-data-into-cortex/entities-overview/entities/groups.md) the entity belongs to. |
| **Domain** | Group data by the domain the entity belongs to. |
| **Entity type** | Group data by entity type (such as services or teams). |
| **Entity owner** | Group data by the user or team that owns the entity. |

### **Version control**

The 'group by' options in this section are specific to version control metrics and let you segment data by pull request attributes.

| Group by | Definition |
| - | - |
| **Repository** | Group data by repository. |
| **Status** | Group data by PR status. |
| **Label** | Group data by PR label. |
| **Author** | Group data by PR author. |
| **Reviewer** | Group data by PR reviewer. |

### **Deployments**

The 'group by' options in this section are specific to deployment metrics and let you scope data by attributes such as environment.

| Group by | Definition |
| - | - |
| **Environment** | The environment sent via the [deploys API](https://docs.cortex.io/api/rest/deploys). |

### **AI tools**

There are no AI-specific 'group by' options. Only **Teams & Users** options apply to AI tools metrics.

### **Project management**

The 'group by' options in this section are specific to project management metrics and let you segment data by project attributes.

| Group by | Definition |
| - | - |
| **Project** | Group data by project. |
| **Sprint** | Group data by sprint. |

### Incidents

There are no incident-specific 'group by' options. **Teams & Users** and **Entity** options apply to incident metrics.

### Custom metrics

The 'group by' options in this section are specific to the custom metrics you created in Cortex.

| Group by | Definition |
| - | - |
| **Domain** | The domain associated with the entity. |

### Scorecards **(table view only)**

There are no Scorecard-specific 'group by' options. Because Scorecard results are evaluated per entity, adding a Scorecard column limits grouping to the **Entity** options and relationship groupings. Team and user options aren't available while a Scorecard column is in the table.

### Relationships

The 'group by' options in this section list the custom entity relationship types defined in your catalog. Each relationship type you've configured (for example, a service-to-repository or account-to-resource mapping) appears as its own grouping option. Select a relationship type to group and roll up metrics for entities connected through that relationship.

Filtering by relationship isn't supported yet; these options are available for grouping only.


## Related topics

- [Data Explorer](https://docs.cortex.io/improve/eng-intelligence/data-explorer.md)
- [Available metrics in Data Explorer](https://docs.cortex.io/improve/eng-intelligence/data-explorer/available-metrics-in-data-explorer.md)
- [Custom metrics](https://docs.cortex.io/improve/eng-intelligence/custom-metrics.md)
