On the JIRA FlowViz - need for more fields

[Karloyski]

Hi Nick,
I went over several discussions hoping to find the answer and found one closest which is data pulled into power BI. I did tried to expand the tables, but just could not get to to it. I would like to add more info into the tooltips for the trhough put visulaitio, I want to add information around sprint name and story points. Can you possibly give me guidance on this? Thank you!

[nbrown02]

1. The first thing you need to do is figure out what those fields are referred to in the API on your specific Jira instance. The field name in my Jira instance won't be the same as yours. To do this, find an item assigned to a particular sprint, in this instance I'm using CIT-1695 assigned to Sprint 70:

2. In the web browser, enter into the URL:

https:// ADD YOUR JIRA INSTANCE HERE.atlassian.net/rest/api/2/search?jql=issue%20%3D%20ADD THE ISSUE ID HERE

So for my issue that's:

https://jirainstanceforourorg.atlassian.net/rest/api/2/search?jql=issue%20%3D%20CIT-1695

3. Do a CTRL+F to find the sprint, (in this example 'sprint 70') and find the customfield name:
   

Write this down as we'll need it :)

4. In Power BI in your report, go into Power Query by clicking 'Transform Data'

5. For any table with 'WorkItems' in the name, select it then go to the 'Expanded Data.Fields' applied step

6. Add in the following to the formula bar:

7. Do the following:

8. You'll then have the sprint details. You would need to repeat this for every work items table.

9. Add this field to the respective tooltip.

[Karloyski]

Wow! This helped a lot. I struggled finding that custom field at first, but with this detailed guide, I was able to get it. Thank you very much again!