Connecting to Jira

  1. When you begin a Jira import for the first time, you will be prompted to connect your Jira instance to Coefficient.

    Screen Shot 2021-08-30 at 2.37.38 PM.png

  2. You will need to give permission to Coefficient to view your Jira data.

    JiraAuthorization.png

Imports from Jira

There are 3 different ways to import data using Coefficient from Jira, Imports from Scratch, Importing a Custom JQL Query, and using Saved Filters. Importing from Scratch allows you to create imports without having to write SQL. Using a Custom JQL Query gives you additional flexibility in the data that you are importing into Coefficient. The Saved Filters option allows you to pull in a filtered view that you created in Jira and import it into Sheets using Coefficient.

Imports from Scratch

  1. Select Import Data → Jira from the list of data sources.

Screen Shot 2021-08-30 at 2.35.52 PM.png

  1. Select "Start from Scratch" from the options provided.

Screen Shot 2021-09-15 at 8.53.19 AM.png

  1. Select the necessary Settings.

Screen Shot 2021-09-15 at 1.15.20 PM.png

  1. Select your fields. Import.

Screen Shot 2021-09-15 at 1.22.34 PM.png

  1. Congratulations on your first Jira import in Coefficient! 🎉

Screen Shot 2021-09-15 at 1.45.44 PM.png

Custom JQL Query

Need help with JQL Query? This article should help.

  1. Select Import Data → Jira from the list of data sources.

Screen Shot 2021-08-30 at 2.35.52 PM.png

  1. Select "Custom JQL Query" from the options provided.

Screen Shot 2021-09-15 at 8.54.07 AM.png

  1. Input your JQL Query

    Screen Shot 2021-09-15 at 2.05.41 PM.png

  2. Congratulations on your successful JQL query import! 🎉

Screen Shot 2021-09-15 at 2.08.22 PM.png