Set a filter for a chart
Set a filter for a chart
Want to filter the contents of charts? We've got you covered since you can filter charts by any available property such as assignee or label. You can also filter by your custom fields. This guide teaches you how to use filters like a pro!
Want to filter the contents of charts? We've got you covered since you can filter charts by any available property such as assignee or label. You can also filter by your custom fields. This guide teaches you how to use filters like a pro!
Want to filter the contents of charts? We've got you covered since you can filter charts by any available property such as assignee or label. You can also filter by your custom fields. This guide teaches you how to use filters like a pro!
Guide contents:
Guide contents:
How to find the filter feature?
Each chart has its own filter. Therefore, to filter the contents of a report, you need to open an individual chart for editing, and then adjust the filter by clicking Set filter in the chart editor:
When you are editing a report under the Reports tab, you access the filter of an individual chart by clicking the Edit chart icon next to the three dots menu:
When you are in the Insights tab, you can filter all the charts at once by clicking the Set filter button on the top toolbar:
Note that when you set a filter in the Insights tab, it only affects what you see. Other users have their own filter.
When you click the Set filter button in any of those views, the same filter modal is shown:
In the filter modal, you can set filters such as label include “bug” or label does not include “bug”. You can also do more complex filters involving number comparisons, date comparisons, etc.
If you add new custom fields to your board, they will be automatically imported and made available for filters after the next data sync (data is synced once per hour). You can trigger sync manually at the integration settings.
How to find the filter feature?
Each chart has its own filter. Therefore, to filter the contents of a report, you need to open an individual chart for editing, and then adjust the filter by clicking Set filter in the chart editor:
When you are editing a report under the Reports tab, you access the filter of an individual chart by clicking the Edit chart icon next to the three dots menu:
When you are in the Insights tab, you can filter all the charts at once by clicking the Set filter button on the top toolbar:
Note that when you set a filter in the Insights tab, it only affects what you see. Other users have their own filter.
When you click the Set filter button in any of those views, the same filter modal is shown:
In the filter modal, you can set filters such as label include “bug” or label does not include “bug”. You can also do more complex filters involving number comparisons, date comparisons, etc.
If you add new custom fields to your board, they will be automatically imported and made available for filters after the next data sync (data is synced once per hour). You can trigger sync manually at the integration settings.
Filtering by assignee, label, board, project, etc.
You can filter by any of the task properties available in your data such as assignee, group, label, board, project, sprint, milestone etc.
The available filters depend on the data source. The common filter for all data sources include assignee, label/tag, data source, workflow state, and mapped state. Depending on the data source, you can also filter by project, section, group, sprint, epic, milestone, version etc.
You can set multiple filters by selecting them one by one. Each filter can have multiple options for is any of or is none of.
Once you have set the filters, click Save to apply the filter to the chart.
Filtering by assignee, label, board, project, etc.
You can filter by any of the task properties available in your data such as assignee, group, label, board, project, sprint, milestone etc.
The available filters depend on the data source. The common filter for all data sources include assignee, label/tag, data source, workflow state, and mapped state. Depending on the data source, you can also filter by project, section, group, sprint, epic, milestone, version etc.
You can set multiple filters by selecting them one by one. Each filter can have multiple options for is any of or is none of.
Once you have set the filters, click Save to apply the filter to the chart.
Filtering by number fields
You can filter charts by any of your number fields. You can find them in the filter options, and you can do comparisons such as is greater than or is less than:
You can also filter by exact match using is equal to or is not equal to:
You can also filter by which items have a value or do not have a value by selecting is empty or is not empty:
Filtering by number fields
You can filter charts by any of your number fields. You can find them in the filter options, and you can do comparisons such as is greater than or is less than:
You can also filter by exact match using is equal to or is not equal to:
You can also filter by which items have a value or do not have a value by selecting is empty or is not empty:
Filtering by date fields
You can filter a chart by any of your date fields. When you select a date field in the filter, you can select within the last, not within the last, within the next or not within the next and enter the number of days:
In the above example, the filter will include items items with Date created within the last 10 days.
Alternatively, you can select before or after, and use the date picker to select the date:
That will select all items with Date updated after the selected date. You use any of your date fields in the filter, including any of your custom date fields.
Filtering by date fields
You can filter a chart by any of your date fields. When you select a date field in the filter, you can select within the last, not within the last, within the next or not within the next and enter the number of days:
In the above example, the filter will include items items with Date created within the last 10 days.
Alternatively, you can select before or after, and use the date picker to select the date:
That will select all items with Date updated after the selected date. You use any of your date fields in the filter, including any of your custom date fields.
Filtering by text fields
You can add any of your text fields as columns to the Taks list. However, a lesser-known fact is that you can also use them for grouping and filtering data.
Before you can use your custom text fields in grouping and filtering, you need to map them as Group & filter first.
Filtering by text fields
You can add any of your text fields as columns to the Taks list. However, a lesser-known fact is that you can also use them for grouping and filtering data.
Before you can use your custom text fields in grouping and filtering, you need to map them as Group & filter first.
Filtering by substring
You can filter by partial text match using Contains or Doesn't contain. You can type the phrase in the filter window. It will be matched against the selected field, such as Label:
Selecting Label Contains "Bug", filters all the items that have the characters "Bug" as part of the label name. That would include labels susch as "Bug production" and "Bug staging".
Filtering by substring
You can filter by partial text match using Contains or Doesn't contain. You can type the phrase in the filter window. It will be matched against the selected field, such as Label:
Selecting Label Contains "Bug", filters all the items that have the characters "Bug" as part of the label name. That would include labels susch as "Bug production" and "Bug staging".
Filtering by task name
You can filter by the name of the item (issue/task/story, etc.) by selecting Item name from the filter menu.
You can enter the full name of the item, or use a substring of the name to include or exclude specific items from the set.
Filtering by task name
You can filter by the name of the item (issue/task/story, etc.) by selecting Item name from the filter menu.
You can enter the full name of the item, or use a substring of the name to include or exclude specific items from the set.
Filtering by timings
You can filter by timings such as total time in progress (cycle time), time in a workflow state, or time logged to a time tracking field.
To find items that have been in progress for longer than a certain number of days, select Time in progress from the filter menu:
To find items that have been in their current workflow state for longer than a certain number of days, select Time in workflow state:
To find items that have spent longer than a certain number of days in a specified workflow state (in the past), you can set a filter like this in the Scatter plot chart:
That would include all items that have spent more than 5 days in the In review state.
You can also filter by time logged to time tracking fields:
That would include all items with more than 100 hours logged.
Filtering by timings
You can filter by timings such as total time in progress (cycle time), time in a workflow state, or time logged to a time tracking field.
To find items that have been in progress for longer than a certain number of days, select Time in progress from the filter menu:
To find items that have been in their current workflow state for longer than a certain number of days, select Time in workflow state:
To find items that have spent longer than a certain number of days in a specified workflow state (in the past), you can set a filter like this in the Scatter plot chart:
That would include all items that have spent more than 5 days in the In review state.
You can also filter by time logged to time tracking fields:
That would include all items with more than 100 hours logged.
Filtering by overdue, blocked, reopened etc.
The status filters are currently supported only in the Task list and Scatter plot charts.
To filter a chart by task status, such as blocked, overdue, or reopened, select Status from the filter menu and choose the items to include from the following dropdown:
The resulting chart contains the items that meet that criteria.
Filtering by overdue, blocked, reopened etc.
The status filters are currently supported only in the Task list and Scatter plot charts.
To filter a chart by task status, such as blocked, overdue, or reopened, select Status from the filter menu and choose the items to include from the following dropdown:
The resulting chart contains the items that meet that criteria.
Configuring a quick filter
In the chart settings, you can configure a quick filter that will be shown on top of the chart. It allows adjusting the chart's content without accessing the chart editor.
In the chart settings, use the toggle to enable the quick filter:
Clicking the toggle reveals the filter options. These are the same options as what you have when setting a filter in the chart editor.
For example, selecting Label from the menu creates a quick filter for the label shown above the chart. The default selection is All labels, and you can filter the content by any available label by picking a label from the menu:
When you select filter criteria from the menu, the chart content is filtered by that selection. It allows quick comparisons between labels, iterations, departments, customers, or any other property you have in your data!
You can limit the number of options in a quick filter by setting the same filter inside the chart editor. The quick filter will contain only the items that are explicitly included in the filter
When you enable a quick filter for a chart, it will be present when the chart is shared with a link, embedded in a website, or added to a report.
Configuring a quick filter
In the chart settings, you can configure a quick filter that will be shown on top of the chart. It allows adjusting the chart's content without accessing the chart editor.
In the chart settings, use the toggle to enable the quick filter:
Clicking the toggle reveals the filter options. These are the same options as what you have when setting a filter in the chart editor.
For example, selecting Label from the menu creates a quick filter for the label shown above the chart. The default selection is All labels, and you can filter the content by any available label by picking a label from the menu:
When you select filter criteria from the menu, the chart content is filtered by that selection. It allows quick comparisons between labels, iterations, departments, customers, or any other property you have in your data!
You can limit the number of options in a quick filter by setting the same filter inside the chart editor. The quick filter will contain only the items that are explicitly included in the filter
When you enable a quick filter for a chart, it will be present when the chart is shared with a link, embedded in a website, or added to a report.