Creating a hyperlink text in Atlassian Analytics to open a Jira Align work item detail panel

[#1]

If you create a chart like a table in Atlassian Analytics with Jira Align data from Enterprise Insights, you can create hyperlinked text with the chart to open a work item detail panel slide out in Jira Align so that your users can view details of a work item in Jira Align. It's an easy way improve the user experience of your dashboard. This article provides instructions on how to create hyperlinked text in Atlassian Analytics with your data in Enterprise Insights using simple expressions to open the detail panel slide out for a work item in Jira Align.

Note: If you have configured single sign-on (SSO) authentication with Jira Align, the detail panel slide out won’t open after user logins through SSO after clicking a hyperlinked text in Atlassian Analytics. The user will be directed to the Jira Align home page. Once a user has authenticated with SSO in their browser instance, the next time the detail panel slide out will open directly from a hyperlinked text in Atlassian Analytics

1. Add a work item ID (ex. [Feature ID]) column to a Visual SQL query and select Run query.

2. In the Result table, select Formula column and Custom. Add a unique identifier value of your choice with single quotes (ex. 'Server') in the expression field. Select Save.

3. Rename the Custom Formula column name to a name of your choice (ex. Server Join).

4. Select Reorder columns. Reorder the new column to be the first column in the result table by dragging and dropping it. Then select Save.

5. Select the Add query dropdown and select New query to create a new query.

6. In the new query, add the [Server] column in the [Site Metadata] table which contains the URL of the Jira Align instance. Select Run query.

7. In the Result table, select Formula column and Custom. Add the same a unique identifier value that you added to the work item query with single quotes (ex. 'Server') in the expression field. Select Save.

8. Rename the Custom Formula column name to a name of your choice (ex. Server Join).

9. Select Reorder columns. Reorder the new column to be the first column in the result table by dragging and dropping it. Then select Save.

10. In the data pipeline, click on the pencil icon in the query join row. Select Inner in the Join dropdown. Select Save.

11. Hide the new column (first column) by selecting the eye icon in the column header in the Result table.

12. Using the solution detailed on this Atlassian Community article, Creating Dynamic Links to Jira Align Work Items for Custom Jira Align Enterprise Insights Reports. Select Formula column in the Result table and Custom to create a custom expression. In the expression field, enter the following “Server” || ‘/[Grid Name]Grid?FirstTime=True&[Object Type]ID=’ || “[Work item ID column]”. Replace [Grid Name] and [Object Type] with the corresponding values for the work item in the table of the community article. [Work item ID column] is the column name of the column with the work item ID value (ex. [Feature ID]). Select Save.

13. Rename the Custom Formula column name to a name of your choice (ex. URL).

14. Hide the Server column by selecting the eye icon in the column header in the Result table.

16. In the Result table, select Formula column and create link with title. Then select the work item ID column (ex. [Feature ID]) for the Select Title Text Column and the column that contains the URL path (ex. URL) for the Select Link Column. Select Save.

17. Hide the work item ID column (ex. [Feature ID]) by selecting the eye icon in the column header row in the Result table.

18. Rename Md Link column name to the work item ID column name (ex. [Feature ID]).

19. Test the hyperlinked text by selecting a value in the column in the Chart preview.

[Huw Pattinson]

Nice article @Sam Tsubota! 

I like to level this up by turning the work item title into a clickable link, rather than having the full URL displayed. Here's how. 

We concatenate (join) the Feature Name column together with the new URL (link). 

The syntax is

[Title](Link URL)

And we use the || to concatenate (join) together the different parts of the title & link.

'[' || "Feature Name" || '](' || "Server" || '/RequestGrid?FirstTime=True&FeatureID=' || "Feature ID" || ')'

Which turns into:

[My Feature Name](https://my-company.jiraalign.com/RequestGrid?FirstTime=True&FeatureID=1234)

And for presentation:

My Feature Name

Save your chart and review in preview or presentation and you'll see your new clickable Title link. 

I then recommend you hide the old Title & ID columns and rename your new one to Title.

[Mary Heather Cox]

Wow, that is a LOT of steps to so something that should be much much much easier to do!

[Huw Pattinson]

Thanks for your feedback @Mary Heather Cox

How would you like to see it work? I can share that with the Atlassian Analytics team.