I’m creating a cube in EazyBi to analyze a Jira SM project.
I especially need to be able to retrieve data based on a ticket type (HotFix) and see if it has any linked incidents. Currently it shows it to me under the names “related to” or “automated in” or “created”.
What field would give me that data? I searched for it but I can’t find it. The one I know, “linked issues”, doesn’t give me anything. I’m attaching an example image.
You can do this in Jira with next syntax:
Issuetype=Hotfix and issueLinkType in (related to,automated in,created)
In EazyBI you can make next in Settings->Advanced settings
[jira.customfield_linked_issues]
name = “Hotfix with links”
outward_link = [“relates to”,“automated in”,“created”]
multiple_values = true
dimension = true
You then check the field “Hotfix with links” or any other name you have given it in Source data->edit-> Issue links Custom fields. Import your data and the you wil see it in you measures where you can use it.