Showing product images in a dashboard

Hello everyone,

I would like to show product images in dashboards - I’ve created a dimension that allows me to show the product images inline, but this takes up a lot of space. What I would really love to do is have the images show up when the user hovers over a product code - is this possible in Looker?

I also wondered if it may be possible to have a text tile showing an image, which could update dynamically as the user clicks on other SKUs, is this possible?

Best,
Ben

I can’t think of a way to do this one. Text tiles on dashboards are pretty much static, they don’t take any kind of liquid or dynamic input.

There’s also no way to have the tooltip HTML be different than the inline HTML, I’m afraid. Both good ideas that would make for some pretty dashboards!

1 Like

izzy - when cross-filtering gets released later in the year would this be possible with a single value field with HTML applied with Liquid embedded and automatically-triggered refreshing on the tile?

Yurp, totally. That was the first thing that jumped to my mind as well, but the operative words there are “later in the year” :slightly_smiling_face:.

Good lookin’ out Ben!

@izzy @bens What is this cross filtering magic of which you speak? :dizzy:

It’s a feature that’s currently in the works that’d allow you to click on a value on one dashboard tile and have it filter other tiles on the dashboard with that value. Will make all kinds of interesting things possible!

You could potentially use the <details> in HTML, for example:

  dimension: dimension_with_picture {
    type: string
    sql: ${TABLE}.column_in_table ;;
    html:
   <details>
     <summary>{{ value }}</summary>
     <p><img height="100" src="{{image_link._value}}"></img></p>
   </details> ;;
  }

gets you:
details

2 Likes

Love this, thanks @brecht!

Genius! Would it be clickable like that in the tooltip, as well?

I don’t think so, tooltips disappear when you no longer hover over the data point, so if you’d hover over the tooltip, it’d disappear too.

When can we expect cross filtering to be available?

This one is still being worked on but without a committed release version, so I can’t speak to a specific date. I’ve mentioned elsewhere that there are general dashboard improvements coming— So rather than build cross-filtering for our current dashboards, release it, and then have to re-model for the new dashboards, we’re building it as part of the new dashboards.

It’s not part of the first “milestone” of the new dashboards, so you’ll likely see earlier beta features of them that do not include cross-filtering, but eventually it’ll be there.

I realize that’s a pretty darn vague answer— I’d give more clarity if I could.

Ok, thanks for the prompt reply Izzy! Look forward to the new dashboards and hopefully, the cross-filtering as well, soon!

Also, can you point me to any discussion on the “new dashboards” please? Would be keen to understand the potential features. Thanks!

There’s really not much discussion on them, I think what little I’ve said about them I probably shouldn’t have :zipper_mouth_face:. They’ll be announced to much fanfare when they finally are, so keep an eye on those release notes!

1 Like