Create Trellis Chart in Tableau for Data Visualization

reate a Trellis Chart in tableau using simple calculations to show a nice high-level view. Trellis charts are a version of a small multiples chart that organizes the dimensions in the view across a grid.


First, create X and Y calculation fields for the number of splits we need in our visualization.

Create a calculated field for the index and convert it to discrete.

The Number of Columns is the parameter where we can set the number of splits per column.


After creating the X and Y fields drag them to the columns and rows shelf and create a date calculated field as shown below.


Now drag the date calculated field to the columns shelf and change to the continuous field. Similarly, drag sales field to rows shelf as a continuous field and sub-category to colour/details in marks card.

After that edit table calculation for X and Y fields by changing compute using to specific dimensions to sub-category and order date.

Now we have got the visualization is done. Let do some more calculations to show the sub-category names in each box.


Create Max Sales calculation as shown below.

Then create a Mid-Point calculation as shown below.

Now drag Mid-Point to rows shelf and edit table calculation and set compute using to order date and add a sub-category to labels in marks card.


Finally dual-axis and remove the headers of X and Y fields and do the necessary format things.

Follow us for more such topics and suggestions.Also, click the link below to follow us in LinkedIn



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store