Learn how to connect and manage your connected Atlassian data and external data.
Learn how to create insightful charts and dashboards with your organization’s data.
Learn how to use Visual SQL to create queries and transform data for making charts.
Need feedback on data? Learn how to share charts and dashboards with teammates so they can leave comments.
Learn how to grant resource access to the people who need it.
Learn how to manage your workspace and how to monitor your workspace activity.
Atlassian Analytics is in an early access program
Only people who are part of this invite-only early access program have access to Atlassian Analytics.
Only want to show data matching certain conditions? This is where filters will come in handy. For filters in a visual mode query, you can filter by any available columns, even if they aren’t added to the “Columns” section.
Add a query filter
You won’t be able to add a filter until you first add a column. Once you’ve added a column, you’ll see the “Filters” section appear within your visual mode query.
To add a filter, select +Add filter in the “Filters” section.
Select a column to filter.
After selecting a column, you’re prompted to select a filter operator. The operator options vary depending on the data type of your selected column.
After selecting a filter operator, you’ll need to provide values to filter for. Type in values manually or select dashboard variables, if any, from the list. Values can be literal strings, variables, etc.
You don’t need to wrap filter values in quotes. And if you have a condition that requires multiple values, you don’t need to type any commas—just press Tab after you type in a value.
By default, filter conditions in visual mode each have an AND between them, which means the data returned must match all the filter conditions. If you only need your results to match some filter conditions, you can change the operator to an OR by selecting the & button that connects the conditions. You can change it back to AND by selecting the button again.
But maybe you need more complex combinations of filter conditions with nested conditions and a mix of ANDs and ORs. To create a new subgroup of conditions, hover over the condition you’d like to include in the subgroup and select the conjunction that appears to the right of it. You’ll then see the option to add more conditions to your new subgroup.
For example, let’s say you wanted to set up the following filter conditions:
Here’s how those filter conditions would look in a visual mode query:
Reposition a query filter
Did you accidentally add a condition to the wrong subgroup? You can drag and drop the condition to the correct position (or use the undo feature to quickly undo it)!
Remove a query filter
To remove a filter, select the X within the filter’s block.
Was this helpful?