Display issuetype or issue url in the cell

Questions & Answers
1

Hello easyBI community,

I have a question about eazyBI reports. Now I have create a simple table to show the links between issues, I attached the screenshot here, the ITSM-18442 caused ITSM-18443, and ITSM-18443 caused by ITSM-18442 and causes CHG-660.

eazyBI
eazyBI1714×441 37.6 KB

I added the colomn “IssueType” at the end but it only showed the issuetype of index issue on the left. I would like to add Issuetype and link of issue(or make the issue name as a hyperlink) into each cell. so we can click the hyperlink to locate to the issue in Jira.

Is it possible to do this?

Thanks in advance.

Regards,
Shuoyu Hu

2

Hi @shuoyuh,

Thanks for posting your question.

It is possible to create the report where you can add hyperlinks for the linked issues & get their issue type as in my example below:

1814×816 83.8 KB

You will need to create following calculated measures keeping in mind that:

  • you would need to replace “Is blocked by” with the name of your issue link

  • add link to your site where it says “YOUR SITE HERE”.

  • choose Formatting → Text → Markdown for the measures with the hyperlinks

Issue is blocked by (hyperlink):

CASE 
  WHEN IsEmpty([Issue].CurrentHierarchyMember.get('Is blocked by')) 
    OR [Issue].CurrentHierarchyMember.get('Is blocked by') = "null"
  THEN 
    ""
  ELSE
    "[*" || 
    [Issue].CurrentHierarchyMember.get('Is blocked by') || 
    "*](http://YOUR_SITE_HERE/browse/" ||
    [Issue].CurrentHierarchyMember.get('Is blocked by') ||
    ")"
END

Issue is blocked issue type:

Generate(
  [Issue].[Issue].GetMembersByKeys(
    [Issue].CurrentMember.getstring('Is blocked by')
  ),
  [Issue Type].[Issue Type].getMemberNameByKey(
    [Issue].CurrentHierarchyMember.get('Issue type ID')
  ),
  ","
)

Issue is blocked by blocked by (hyperlink):


Generate(
  Filter(
    [Is blocked by].[Is blocked by].GetMembersByKeys(
      [Issue].CurrentHierarchyMember.Get('Is blocked by')
    ),
    NOT IsEmpty(
      [Is blocked by].CurrentMember.GetString('Is blocked by')
    )  
  ),
  Generate(
    [Issue].[Issue].GetMembersByKeys(
      [Is blocked by].CurrentMember.GetString('Is blocked by')
    ),
    "[*" || 
    [Issue].CurrentMember.key || 
    "*](http://YOUR_SITE_HERE/browse/" ||
    [Issue].CurrentMember.key ||
    ")"
  ),
  chr(10)
)

Is blocked by blocked by issue type:

Generate(
  --set on linked tests
  {Filter(
    [Is blocked by].[Is blocked by].GetMembersByKeys(
      [Issue].CurrentHierarchyMember.Get('Is blocked by') ),
    NOT IsEmpty([Is blocked by].CurrentMember.GetString('Is blocked by'))  
    )},
  Generate(
    [Issue].[Issue].GetMembersByKeys([Is blocked by].CurrentMember.GetString('Is blocked by')),
    [Issue Type].[Issue Type].getMemberNameByKey(
  [Issue].CurrentHierarchyMember.get('Issue type ID')
)
  ),
  chr(10)
)

Best,
Marita // support@eazybi.com