In a Looker report I wanted a list of analytical reports that I could click on to open each individually.
With a data source containing two columns ‘Report_Name’ and ‘Report_URL’ I added a table to the report surface.
Within the table properties I removed the default metric (Report_URL), and selected ‘add dimension’ then ‘add calculated field’.
For display-name I typed ‘Report Name’ and for formula I typed ‘HYPERLINK(Report_URL, Report_name)’.
When I clicked Apply the data-type property changed from Text to Hyperlink. I waited until the report communications with the data-source had finished, then I clicked the report surface to remove the properties box.
Finally to clean up, I removed the default measure (Report_Name) and waited, then I changed the Sort order to ‘Report Name’ descending (and waited), then in the style tab I deselected ‘Row Numbers’.
Database Consultant 