Using row contents in a URL link

[garnold]

I have a column with a fully qualified URL in it. I understand how to use this for navigation but there is an issue that I was hoping I could get help with. Since the URL is fully qualified it starts with http://. If I just add the contents into the navigation control it does not work because QuickSight adds https:// to everything. Right now I’m using the REMOVE function to trim off the first part of the URL so that QuickSight does not get upset but that requires me to have a new custom field. Can I use functions in other areas of QuickSight? This is not working in the URL text box but could I just be doing something wrong?

[DeepakS]

@garnold, like you mentioned QuickSight URL action requires https:// specified in the URL action field, so option is to create a calculated field and include that field into your say table visual and you can hide that calculated field and still use it as part of the URL action something like this “https://<<{URL without http}>>”. Here is democentral example for reference.