Using Dynamic Hyperlink in Layout Editor (.xpt template)

Summary:

I have a report using .xpt template / Web layout editor, there is a text Goal Center that I need to convert to a hyperlink so users can go directly to My Team > Goals Center. This needs to be dynamic to be applicable across all our environments.

Content (please ensure you mask any confidential information):

1. I tried creating a data set with the following query:

SELECT
(SELECT addom.external_server_protocol || '://' || addom.external_virtual_host
FROM ask_deployed_domains addom
WHERE addom.deployed_domain_name = 'FADomain')||'/fscmUI/faces/deeplink?objType=MANAGE_DEVELOPMENT_GOALS&action=NONE' AS DEEPLINK_URL