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




Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Numba: “weapon of mass optimization”

The Allais Paradox

Inferential statistics and its importance in Machine Learning in simple terms.

Predicting the NFT Hype?

Formula 1 and Machine Learning

Basic Program for Linear Regression in Octave

Learning by doing: a data scientist’s guide to effective work-school balance

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
Sphyzee Analytics

Sphyzee Analytics

More from Medium

Bar charts are a very basic way to represent the data.

An approach to better visualisations with Gauge Chart

Figure 1: Gauge Chart , photo retrieved from:

ReVIZiting the humble supermarket receipt

Reviziting the humble supermarket receipt — data visualization experiment | Blog | Datylon

A Best Practice in Power BI might Cause Big Problem