PictureThis Product Guide

The “PictureThis” Premium extension for Tableau helps you create dynamic image grids or tables that can be used as an interactive filter in your dashboards. 

With just an image url in your dataset, the PictureThis extension dynamically generates a clickable image grid or table to be used as a filter or be filtered upon. No need to download or prep loads of images and manually define tons of url actions, this extension gets you started right away. Use your image grid or table as a filter in your dashboard without defining a single dashboard action. 

A getting started video can be found here: https://youtu.be/TOz6wplZHWQ 

This Product Guide explains how to use all the brilliant options of the PictureThis extension when you are creating a dashboard containing the interactive PictureThis Image Grid or Image Table. Below all the options of the “Configuration Screen” are explained. The content of the Configuration screen can differ from your version of the extension, we constantly keep improving and expanding the functionality extension which might result in new configuration options. If you want to keep track of all innovations, subscribe to our Quarterly “What’s New” webinars where we will keep you posted! 

A quick tip before you start: In general when you are working with Extensions, it is Best Practice to create a dedicated “datasheet” for your extension. This allows your general dashboard actions to interact with this datasheet and your Extension will dynamically respond to that. How to create a Datasheet for your PictureThis extension is explained here: https://youtu.be/TOz6wplZHWQ?t=57 

Configure Screen

Once you have created your datasheet and added it to your dashboard you can start adding your extension to the dashboard. 

Use the dropdown menu of the container that holds your extension and select the “Configure” option.

Configure Screen in PictureThis

This will open the configuration screen of the PictureThis extension.

Open configuration screen PictureThis

Select Data Sheet

The first you must do to configure your extension is select the datasheet that holds the columns that you want to use in your PictureThis Image Grid or Image Table. In your preparations it is important to first add the datasheet to your dashboard before configuring the extension. As stated before, it is highly recommended to use a dedicated datasheet for the extension (holding only the information necessary for the PictureThis extension). The datasheet needs to be present on the dashboard, but can of course be made invisible. A nice trick to do this is to make the datasheet floating and resize it to 1×1 pixels in Width and Height.

Now in the configuration screen select the worksheet you want to retrieve data from. This worksheet will be the input for PictureThis. You can always add extra fields to this datasheet and open the configure screen again to use them in your PictureThis extension (labels, colors, links etc.).

WARNING: Please do not change the name of your datasheet nor your dimensions and measures. Extensions store your configuration with a reference to the sheet names, dimension names and measure names. Changing any of these will force you to re-configure the extension.

Settings

Which column contains the image URL?

This setting is crucial for the PictureThis extension. You can see the list of fields (dimensions and measures) that are available on the datasheet you selected in the previous step. Just select the dimension that holds the url to your image. This must be a “http://” or “https://” url that is free accessible and not password protected. The image must be of the format jpg, png or gif.

Select additional data to display (optional)

You can show Additional information that will be shown in the Image Grid or Image Table. The additional information will be shown on an image level. The order they are chosen will be the same order shown within PictureThis. By default formatting (decimal, currency, percentage etc.) will be used from the default formatting options per dimension or measure in your datasheet.

Select layout

PictureThis has two basic layouts ‘Cards layout’ & ‘Table Layout’. Cards layout will show the images as a card with information underneath for example (the Image Grid). Table layout will result in a table showing your image present alongside your additional information on the same row.

Color

Change the background color of the extension container by using the color palette. Beware that the cards of the image grid or table are drawn on top of this background color.

Change the card background color by using the color palette. The image will be placed on top of this card background color.

Use the palette to choose the banding colors of your cards

Choose a color to be set for the card border.

Change the color of the text shown alongside your images in the Image Grid or Table by using the color pallete.

Change the basic row color by using the color palette.

Use the palette to choose the banding colors of your cards

Use the palette to enable row banding and choose the second color for row the banding.

Conditional card color

Use the tick box to activate conditional coloring of your Cards. You can use one of the columns in your datasheet to trigger conditional Card coloring. This makes the special Cards stand out of the rest.

Choose the dimension and customise each card with their own color using the color palette. You can create something like the image below:

Conditional card coloring PictureThis

Formatting

All fields you selected to be present in your Image Grid or Image Table can be Aliased and formatted according to your wishes. Change to a decimal, percentage, text or even a barcode! Add an alias on each as well as a prefix and a suffix.

Customize card content (Card Layout only)

Use the tick box to activate your custom card content. Here you can customize the content shown on the cards of your Image Grid. Add text and fields and customize exactly how you wish by using html and Bootstrap classes and styles. You can use the available fields only once. If you need to use a field twice, just duplicate it (use a different name) on your datasheet and the same field will be available twice (with a slightly different name). You can use html and bootstrap to customize the card content.

Best Practice is to remove the Aggregation methods from measures to support multilanguage Tableau deployments. For example if you want to use the Sales Measure in your Cards replace the “SUM(Sales)” by just “(Sales)”. This is necessary since the aggregation methods (Like SUM and AVG) have different names in different Tableau Localizations.

Tooltip

If you want to use a tooltip on your Cards or Table cells, use the tick box to enable it. Here you can configure what content is shown in your tooltip. Add text and fields and customize exactly how you wish. You can use fields only once. You can use html and bootstrap to customize the card content. Remove the agg methods from measures to support multilanguage Tableau deployments. For example SUM(Sales) à (Sales)

Layout – Table Layout

Enter the width you would like the table to be in pixels. Leave this field empty for auto width settings (100%).

Click to turn on or off the display of Column headers in your Table view. The Headers will be ‘sticky’ headers and they will keep their position even when you use the scroll bar.

Enter the height you would like the image to be in your PictureThis Image Table. Use a number of pixels, for example: 100px

Cropping the image will fill the area, keeping the image in proportion. This option makes sure all images fill the same space in your Image Table which usually results in a consistent clean view. Part of the image can be invisible since that will be cropped if the image does not exactly meet the crop aspect ratio.

This setting (padding) determines the space between the edge of the Table cell and the image. This will make sure that your mages are not glued together in your Image Table. Choose the image padding range within your Table cell using pixels. For example: 4px to generate 4 pixels of whitespace around the image

Here you can set the padding (whitespace) between the rows of your PictureThis Image Table. Set the row padding using a number of pixels. For example: 10px

Here you can set the column where you want to sort your table on. It is optional and allows you to sort either Ascending or Descending. Choose your Sales measure in descending order to sort your rows on the best selling products…

Choose between Ascending or Descending order for sorting your rows in the PictureThis Image Table.

Click to show a print button. This will be placed in the bottom right of your PictureThis extension and is sticky so it won’t disappear when scrolling your Image Table.

Layout – Cards Layout

Enter the column width in % or px. PictureThis will automatically calculate the right amount of columns. Example: 10% or 150px.

You can show your cards with a slightly rounded border. Using % or px enter your Cards border radius.

Enter the height you would like the images to be in pixels. This will make sure your images are shown in the size you prefer. Example: 100px

Cropping the image will fill the area, keeping the image in proportion. This option makes sure all images fill the same space in your Image Grid which usually results in a consistent clean view. Part of the image can be invisible since that will be cropped if the image does not exactly meet the crop aspect ratio.

This setting (padding) determines the space between the edge of the Image Card and the image. This will make sure that your mages are not glued together in your Image Grid but have a small whitespace between them. Choose the image padding range within your Table cell using pixels. For example: 4px to generate 4 pixels of whitespace around the image.

Choose the card padding range using pixels. This will set the whitespace between the card and the image. The whitespace will be filled with the Card Background color. Example: 4px

This option will set the margin between cards in your Image Grid. The whitespace will be filled with the backround color set in the “Color” configuration. Choose the card margin range using pixels. Example: 10px

Here you can set the column where you want to sort your table on. It is optional and allows you to sort either Ascending or Descending. Choose your Sales measure in descending order to sort your rows on the best selling products…

Choose between Ascending or Descending order to sort the Cards in your Image Grid.

Click to show a print button. This will be placed in the bottom right of your PictureThis extension and is sticky so it won’t disappear when scrolling your Image Table.

Decide how many cards to be shown before every new page. Leaving blank will be done automatically with the risk that a page break will be initiated half way a card.

Label

Text Format

Here you can set if you want the first field you selected to display in either the Cards or Table view to be printed in Bold or plain cast.

Text Align

In Table view you generally want to align your text to the left (or right when in an RTL region) while Cards view often looks best when text is centred in the Label of the Cards. This option allows you to setthe alignment of the text in your card or Table cell by choosing Left, Centre or Right.

Font size

Use the dropdown to change size of the font. Min size 6pt, max size 24pt

Font Family

Change the font from the dropdown to improve the look of your dashboard and match your Identity.

Dashboard actions

Action Type

PictureThis supports different types of Dashboard Actions. This Action Type setting allows you to set two of them; the Filter Action and the Highlight Action.

The Filter Action makes sure your target sheets get filtered when you select one or more images in the Image Table or Image Grid. The Highlight action will not filter the target sheets but highlight the marks that belong to the selected image in you Image Grid or Image Table.

Target Sheets

Decide which sheets will be triggered with your chosen Dashboard Action (Filter or Highlight).

Selected Field

Decide which field you want to select to trigger the dashboard actions on your Target sheets.

Filter type

Sometimes you want a dashboard action to be triggered on a single select only, sometimes you want to support multi selections as well. This option allows you to switch between both filter variations.

Parameter Action

A very powerful feature of the PictureThis extension is the Parameter action. You can set the value of a parameter by clicking the image in either your Image Grid or Image Table.

This configuration option lets you select the parameter you want to update on a selection. In the example below the parameter “PM Selected SKU” will be updated with the SKU when I select a product in my Image Grid of PictureThis:

My image grid PictureThis

It is important to have a parameter of type String that allows all values otherwise it will not be shown in the list of “Target Parameters”

URL Action

Another powerful action type is the URL action. This feature allows you to navigate to a url in a (new) Browser window just by clicking one of the images in the Image Grid or Image Table. You can use a calculated field to generate your target URL and add it to your datasheet. In the example below I have set the URL Action to navigate to my “Target URL” which is a calculated field that resides in the Data Sheet that feeds the extension

URL action Picture This

So when clicking on an image in the PictureThis Image Grid or Image Table, it will open a new browser tab showing the “Target URL”.

This is a powerful feature that can perfectly be used to navigate to another published dashboard and use the selection in the present dashboard to set filters while opening the new dashboard.

For example I can create a calculated field that navigates to my published dashboard called “salesmanager” in my “sales” workbook and it will be filtered on the selected product (SKU).

Calculated fields in PictureThis

We love to make solutions and help Tableau users to do things more efficiently. If you have feedback, ideas, questions or need support, please make sure to share it with us! Also, don’t forget to follow us on social media for our latest news and updates.