Last tested: Oct 30, 2019
There's a few components to this, but it's easier than you might think! At a high level we will be using Liquid and a bit of front end wizardry.
### we're starting with this field, which references a database column with customers
dimension: customer {
type: string
sql: ${TABLE}.customer ;;
}
dimension: customer_img {
type: string
sql: ${TABLE}.customer ;;
### each if statement should be evaluating the field, then spitting out an image
### replace customer here with the name of your field
### replace the values with the values from the database column
### insert elsif statements for more images
html:
{% if customer._value == "customer1" %}
<img src="https://www.mydomain.com/images/myimage1" />
{% elsif customer._value == "customer2" %}
<img src="https://www.mydomain.com/images/myimage2" />
{% else %}
<img src="https://www.mydomain.com/images/myimage1" />
{% endif %} ;;
}
Navigate to your explore and do the following:
customer
(any value)customer_img
fieldYour Explore should look something like this:
Add that to a dashboard and we're on to step 3!
With the explore from step 2 on your dashboard as a tile, do the following:
field filter
on the the column that holds all your customer/brand
names.Tiles to Update
add the image tile and select the customer/brand
name fieldallow multiple filter values
Your filters will look something like this:
Voila!
This content is subject to limited support.