Assortive dimensions

by Alexandra Hanna

Because our client project with Virgin Atlantic at Data School was really successful, I wanted to share a little trick we used for improving dashboard user interactivity. I highly recommend the ‘Sort by dimension’ technique to be applied to an overview dashboard, for example one with a set of Key Performance Indicators (dimensions) organizing measures.  Here I am using the Sample Superstore data that comes with Tableau.

1. Build a view with 3 or more dimensions (optional: separate dimensions onto different worksheets) for a single measure:


2. Create a string parameter with the names of the dimensions above:


3. Create a calculated field based on a conditional statement of the Sort by dimension parameter (purple) and respective dimension (orange):


4. Edit sort on each dimension by choosing the ‘Sort by’ calculated field:












5. Show parameter control and test:

Sort by dimension












What dimensions are you sorting? Let me know on Twitter how this technique has come in handy.


Alexandra Hanna

2 mins read

Mon 02 Nov 2015

Thu 29 Oct 2015

Tue 29 Sep 2015

Sun 06 Sep 2015

© 2022 The Information Lab Ltd. All rights reserved.