Caclulations in Jira

Question

Hi everyone,

I finally managed to connect Jira and PowerBI thanks to this amazing Github page.
It is possible to bring all your jira issues fromm all projects and filters to PowerBI. However, the template does not include labels. Maybe someone knows what to edit in Advanced editor so it also gets labels as well?

So what I want is to see a monthly percentage of FastTracks. For that, subtasks with 'FastTrack' label should be divided by the total number of subtasks. Let's say, I have 500 subtasks in total and 25 of them have 'FastTrack' label, hence 25/500*100= 5%. I am curious if it is possible to achieve this in Jira so I can later bring this filter to PowerBI?

BenWade · Answer

Hi Marc, you are right. this questions doesnt belong here. Have to ask it in the PowerBI community.

Marc -Devoteam- · Answer

Hi @BenWade

There are apps on the marketplace that are able to provide data from Jira to PowerBi.

See: https://marketplace.atlassian.com/search?query=powerbi

To get the template altered, talk to the creator of the scripts or ask a developer to help you with your request.

The question you are posting is a BI related task.

This is why you want your data in PowerBI to achieve the asked question, otherwise in my opinion why export your data to PowerBI