Overview: Query Builder for Jira
With the Query Builder for Jira, you can create Custom Jira Metrics using a combination of Metrics, Dimensions and Filters.
How to access the Query Builder for Jira
Navigate to Metrics > Query Builder to access the Query Builder for Jira. Click the green + Create Custom Metric button and select your connected Jira Account from the Data Source drop-down list.
Query Builder is available in Plus and Business Accounts. Agency Basic Accounts have access to Query Builder in the Agency Account only. Request a trial of Query Builder by following
How to use the Query Builder for Jira
The Dimensions parameter re-categorizes the returned Metric value based on common criteria. Examples of Dimensions are "Assignee," "Project," and "Features." If no Dimension is selected, the Custom Metric will store 1 aggregated Metric value for each Date Range.
Pro Tip : If you don't know which Filters to put in place for your use case, use the Dimension + Data Preview to troubleshoot and get more insight into the data that is returned from your ira Account for each field. Learn more here.
How to create a Custom Jira Metric [Example]
In this example, we'll create a Custom Metric to report on Progress, split up based on the Creator. We only want to include tasks that are labeled "Urgent" or "High" Priority.
How to add a Custom Jira Metric to a Databoard
Learn how to add a Custom Metric to a Databoard here.
- Only the first 15 Values returned will be displayed in the Value drop-down list. Follow these steps to determine the exact Filter Value and manually enter it into the Value field.