Is there a built-in way for us to take a user to the data that they drill down to, and in my case, using the Case Safe Opportunity ID field, have it be clickable to launch them into SFDC to view the opportunity/account details?
You can link to any url by creating a table card in your drill path and then construct the proper html tag to build the hyperlink. Here is one example of how to do it:
https://dojo.domo.com/main/discussion/52683/domo-ideas-conference-beast-modes-images-and-hyperlinks#latest
@MarkSnodgrass I found an existing field in SFDC `Account Link` which will take you to the root Account record, but getting to the opportunity will require a very manual process.
However, the URL is imported into Domo in the HTML tag format and is not an active link, so I'm trying to figure out now how to reformat in ETL or Beast modes how to leverage the data imported into an actionable HTML link.
Imported Data Format `<a href="https://companyname.my.salesforce.com/0011Q00002ErH31" target="https://companyname.my.salesforce.com/0011Q00002ErH31">Link Here</a>`
`CONCAT('<div><a href=`Account Link`','"target="_blank">','`Account Name` Link','</a></div>')`
This formatting in Beast Mode is not allowing the data fields to populate the URL string, unfortunately.