1. Create a new workbook and connect to your data

  2. Create a new worksheet, drag and drop either to rows or to columns an ID and a chemical structure format. Rename the worksheet to ‘Single Structure Feed’ by double-clicking on the tab name. 

  3. Create a new dashboard, drag, and drop the created worksheet to the view (you can find out more about the Tableau Workspace here).

  4. Go to ‘Objects’, select ‘Extensions’. Add the Single Structure extension to the dashboard

  • Select the extension, click on the arrow, select ‘Configure’

  • Select the worksheet you created as the ‘Source Worksheet’ (it should be the only one available currently)

  • Select your chemical file format (e.g. SMILES, MOL, INCHI, etc.) as ‘Structure Column’:

  • Create a new worksheet. From now on we will refer to this worksheet as 'Data Table'. You may create any sort of visualisation you wish for this worksheet and connect it with the Single Structure Extension.

  • Drag and drop structure_id to either rows or columns.

  • Drag and drop data from the dataset that you would like to include in your table view.

  • Go back to the dashboard with the Single Structure extension.

  • Drag and drop the ‘Data Table’ worksheet onto your View. Now you have to set it up as a filter by selecting the 'Data Table' worksheet, which becomes active this way and you can click on the funnel on its right side:

  • Select the Single Structure worksheet. Select ‘Layout’ on the Side Bar. Insert a tick next to ‘Floating’. Resize the worksheet to something small. E.g. w:1, h:7:

  • Save your workbook. Reload the page.

  • Expected behaviour: if you select any row from your data table, the Single Structure extension should change the compound image accordingly: