In Amazon Quick Sight, how can I make URLs in a pivot table column clickable? Currently, my website links are displaying as plain text, and I want dashboard users to be able to click these links and open them in new browser tabs. What are the recommended methods to transform these static URLs into interactive, clickable hyperlinks?
Hi @hprem
Welcome to Quick Sight community!
Sorry, URL rendering is not directly available in the Pivot Table. However, you can consider the below workaround.
You can render URLs as links in a Table by using the Field styling pane in the format visual menu.
Workaround for Pivot Table:
You can use a workaround involving URL actions. First, edit the pivot table by navigating to Format Visual and selecting Interactions. Then, choose âAdd URL actionâ. Before setting the action, you need to remove the âhttps://â part from the URLs in the original field. In the URL Action setup, you can manually add âhttps://â as a prefix and then append the field containing the remaining part of the URL. This configuration will allow the links to be formatted correctly and make them clickable for users, seamlessly opening in a new window.
Thank you, @Xclipse! I tried both the solutions and they work.
A follow-up question: Is there a limit on how many links I can show in the visual? I am currently in the testing phase but wondering if there are any limitations with either approach.
Hi @hprem
I looked through the Quick Sight documentation and couldnât find any specific limitations regarding the number of links you can display in a visual. It does mention that you can add up to 500 rows of links per page in a table, with only âhttpsâ and âmailtoâ hyperlinks supported.
1 Like