Looker Studio Clickable Images

[Recrust]

Hi folks,
I have created a looker studio, who is taking data source from a Google sheet, and ultimate data is coming from Google form. The data has Google Drive links which has images in them. I am able to successfully view the image in looker studio. But I want to make them a clickable link so that I can zoom the image and see that any time.

[lauratilton]

See "Example 3" on this help page which explains how to use HYPERLINK and IMAGE together to create clickable image links.

(Side note: In the past, Google Drive images needed their URLs modified in order to be useful in Looker Studio, although maybe that has changed or maybe you have already overcome that hurdle?)

[Recrust]

Hi, Thanks for your reply, I am not really sure what you are talking about.

But i am able to see images via Thumbnail Link.

I didn't really get this in Example 3 that how i can create clickable images?

like they have just used Hyper link formula. Do i need to use this formula in my google sheet, and when i will click them in looker studio it will automatically pick up the google drive link and open the image?

Currently i am using formulas like this,

=ARRAYFORMULA(SUBSTITUTE(INDEX(Form_Responses2[Product Image]),"open","thumbnail"))

Hope you got my point, Apologies if i was not very clear at first instance.

Now this is the formula i am trying to into looker studio
hyperlink(IMAGE(Overview Image of Area),"Overview")

But its not working for me, Like it is removing the image and showing me the text in looker studio.

[lauratilton]

The HYPERLINK is used to create a calculated field that brings together a URL field and an Image type field, like this HYPERLINK(URL, Image). If the image lives at a different URL, you'd have to make it an image field using IMAGE(ImageURL,"Alt Text"). So if you put that all together, you'd create a field in your table like this: HYPERLINK(URL, IMAGE(ImageURL,"Alt Text"). Theoretically if URL and ImageURL were the same field, you'd be able to display the image in the table, then hyperlink it to itself.

That said, I don't seem to be able to get this to work at all currently (not sure if there's a bug or ?) , but definitely have done clickable images using this approach in the past.

[jobC]

I can't get this to work either, and I'm even pulling an image directly from a hosted service. The image displays fine in it's own field, but when I try to append a Hyperlink to create a clickable image, it doesn't work.

[Recrust]

I will be waiting for your reply.

[ArkadyZagdan]

@Recrust My understanding is that you would like it to react similar to Google Drive. When you click on the image it brings the zoomed version of it.
Unfortunately, it's not doable. However, you can do a work around. considering your images are in great resolution you can do a front-end this way that besides the table with all data you can reate a second table with one column only. Make column wide and limit to one row only. This way you will always see a large version of an image you clicked on using the detailed table.

Happy New Year!
Arkady Zagdan