I need to be able to create a hyperlink in table visual and then set the displayed value to field or parameter. I am able to create the calculated field but when I try to use field styling to select custom link seems to treat as one string and not a field or parameter. AI seems to point setting up field as value to display and then select custom text and set to the url string. I have tried this both ways with no success. Can we not take a URL string in a table visual and use styling to change to standard hyperlink that values changes to field or parameter in the visual?
Hi @Sanders77,
Could you provide a bit more detail on what you’d like to do?
What do your ‘stock url’ field values look like? Just to confirm, ideally you’d like to take the field value and place it within a url…which will then make it a proper url for the hyperlink?
If you’re looking to add a parameter value into a hyperlink; wherever the parameter value falls within your url, you’ll want to style it as <<${ParamName}>>
Thank you Brett
I am able to create the hyperlink adding multiple parameters without issue, however I want to be able to restyle the link from url to the actual value in either the parameter or a field. Example below.
http://bogus.url.com/<<$ParamName>>/<<$ParamName2>>
restyle in table via Custom link to measure or dimension from data set ideally.
Hi @Sanders77,
You could try creating a calculated field using the concat function:
concat("https://bogusurl.com/", ${Parameter1}, "/", ${Parameter2})
Then you can replace the current field in your table with the above calculated field and set it to a hyperlink.
Also, if there is a dataset field that returns the beginning of the url, then you can use that dataset field in the concat function instead.
That way you can format this as a hyperlink in the table. The custom link that you highlighted in the first image is static, whereas you want this functionality to be managed dynamically. That will be the best way to accomplish this.
Hi @Sanders77,
Following up here as it’s been awhile since we last heard from you; did you have any additional questions regarding your initial post or were you able to find a work around in the interim?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you
Think I did a poor job of describing the need I can create the url needed with multiple parameters and then use field styling to set as hyperlink without issue. However what I am still unable to do is replace the hyperlink text with the value from measure in data set. I can replace hyperlink text with icon preloaded “chain” or static text but I assuming we must be able to load custom graphic or value in measure from dataset to display?