title: How to use calculated fields to create a hyperlink in Community Connectors
body: <p>I'm building a custom Community Connector for Google Data Studio, and I'm running into trouble trying to create a hyperlink field.</p>
  
  <p>I have been able to manually create a <a href="https://support.google.com/datastudio/answer/7431836?ref_topic=7041728" rel="nofollow noreferrer">HYPERLINK field</a> through the GDS dashboard, but I want to have the Hyperlink field built into my connector, rather than need to be manually created.</p>
  
  <pre><code>fields.newDimension()
      .setId('Hyperlink')
      .setType(types.URL)
      .setFormula('HYPERLINK($IssueURL,$IssueKey)');
  </code></pre>
  
  <p>It should take the $IssueURL and create a hyperlink to it with the link text being the $IssueKey, however it just appends the $IssueKey in front of the $IssueURL and try's to make a link to that (Ex: IssueKeyhttps://www.mywebsite.com).</p>