JQL – Jira Query Language. Jira allows you to link your data from Jira and automatically update your key result progress using the JQL query.

What you can do with Jira JQL and Profit.co Integration?

Profit.co integration with Jira allows you to link your data from Jira and automatically update your key result progress using the JQL query. You can use Jira integration to track the progress of issues and projects. Whenever you check in your key result it fetches the data from Jira and also automatically synchronizes the data every 24 hours.

Integrating Jira with your Profit Account

 

Step 1:

Navigate to Settings from the left navigation panel.

Click on Integrations, On the Connectors page, Select the Business Level tab and click on the Jira JQL Manage button.

all_my_okrs
integrations

Step 2:

Click on the Connect to Jira button and in the pop-up enter the name you wish to give for this connection. First, give the connection type in the Environment as Cloud type.

In the next box, enter the sub-domain name of your Jira account. Finally, enter the API key and press Connect.

connect_cloud

Step 3:

To get the API keys, log in to your Jira account and click on the settings icon on the top right corner and press the Atlassian account settings.

Atlassian Account Settings

You will be redirected to the settings page. In the Security tab, click on Create and manage API tokens and copy the API you have created.

Portal
Portal

Step 4:

Paste the API token and press Connect. This will establish a connection between your Jira and Profit.co accounts.

Manage Jira Accounts

Automating Key Results with Jira using JQL query

Step 5:

In your OKR page, click on add a new key result button under any OKR and select using the form or step-by-step method.

add_kr

Select Increase, decrease, or control KPI key result type to connect Jira data to your KPI. In this example, the key result Increase Resolved open issues from 0 to 25 is selected. Enable the toggle next to the connection icon to link you Jira data to this key result.

Authorize

Write your JQL query and click run to check the current value. Update the icon and save your key result.

update

Step 6:

Now your key result progress has been automated. Every 24 hours the system captures the data from Jira and updates it here or you can drag the key result slider to fetch the current data and update it yourself.

checkin

The JIRA JQL Supported KPIs are below and you can choose which is required

Jira JQL KPI Description
Task Count Track the number of Tasks available in the given JQL query.
Story Points Track the total sum of Story Points that is available in the given JQL query.
Progress The Progress (Percentage) is calculated based on the number of done Tasks in the given JQL vs overall Tasks available in the Given JQL.
Time Spent Track the Sum of Time Spent on tasks available in the given JQL Query.
Time Original Estimate Track the Sum of Original Estimated Time on tasks available in the given JQL Query.
Story Point Estimate Track the Sum of Story Point Estimate available in the given JQL Query.
Story Point % The Story Point % (Percentage) is calculated based on the number of done Tasks StoryPoints Sum in the given JQL vs the overall Tasks StoryPoints sum available in the Given JQL.
Remaining Time Track the Sum of Remaining Time available in the given JQL Query.
Progress % by Task Hours Track the Percentage of the Logged time of Done Status Tasks Vs Estimated Time of Done Status Tasks in a given JQL Query

Notes: The Time-related KPIs will show values only when we choose the Time-based KPIs in Profit.co.

 

Integrating Jira Data Center with your Profit Account

Step 1

Navigate to Settings from the left navigation panel.

Click on Integrations, On the Connectors page, Select the Business Level tab and click on the Jira JQL Manage button.

all_my_okrs
integrations

Step 2

Click on the Connect to Jira button and in the pop-up enter the name you wish to give for this connection. First, give the connection type in the Environment as the Data Center.

In the next box, enter the connection URL. Finally, enter the API key and press Connect. To get the API token please follow step:3 otherwise move to step 4

connect_datacenter

Step 3

To get the API keys, login to your Jira account and click on the settings icon on the top right corner and press the Profile option.

profile

You will be redirected to the Profile page. In the Security tab, click on Create and manage API tokens and copy the API you have created.

create_token
New API token

Step 4

Paste the API token and press Connect. This will establish a connection between your Jira and Profit.co accounts.

manage_jira_connection