Adding the URL property to the issues cube?

[BiNoob]

Hi,

I understand I can left click and then click on “Go to source” when working with the issue cube, however I would like to be able to create an additional column with a clickable URL in it. I have found some information which at first seemed to be helpful, but I’m struggling to put it all together. Here is what I found:

The following page which discusses how to augment the issues cube:
https://docs.eazybi.com/eazybi/data-import/data-from-jira/additional-data-import-into-jira-issues-cube

I also found the following which talks about the URL property:

Hyperlinks in Table Report?

That would be great for us too.

My desired outcome: To add an extra column to the issues cube which will give a clickable URL instead of the user having to left click and then click on “Go to Source”.

TIA for the help.

[ilze.krauze]

Hi!

There is a formatting option Markdown, that allows creating clickable URLs.

For example, if you want to show the issue link in the report as a clickable URL, you can define a new calculated measure “Issue link” in Measures, and change the formatting to Markdown. The expression for constructing the issue URL might be like this:

 CASE WHEN [Issue].CurrentHierarchyMember <> [Issue].CurrentHierarchy.DefaultMember
 THEN
 "[go to Jira "||[Issue].CurrentHierarchyMember.Key||"]("||
 "https://YourJiraDomain.atlassian.net/browse/"||
 [Issue].CurrentHierarchyMember.Key||")"
 END

More information about markdown and custom formatting options can also be found here: Measure formatting (markdown and custom)

Kindly,
Ilze