You can follow this steps to achieve this. The below is my table before applying the changes, I have a column called link and it has some https link (Using field styling - Amazon QuickSight)
Step 1 - CLick on the properties of the visual
Step 2 - Go to field styling → Select your field that has link → Make URLs as hyperlinks → Custom link and type your number there.
You can see in the image my column has changed to the custom text i have given
Note - For this part (‘Select your field that has link’) - If you don’t have a column with link and would like to add to the existing visual, then you can create a calculated field and add link as a string - something like this - (‘Using field styling - Amazon QuickSight’)
Helpful resources -
- Using field styling - Amazon QuickSight
- Is there a way to add hyperlinks to a specific column in Table?
Let me know if this solution helped you!
Thank you,
Shravya