• Bernard

Tableau Tips: Adding Ordinal Number Suffix

Updated: Sep 3, 2020

Ordinal numbers tell us the position of an item in a list, such as 1st, 2nd , 3rd , 4th etc. In this article, we will demonstrate how adding ordinal numbers can help us tell meaningful data stories with Tableau.

A simple use case of adding ordinal number suffix could be as follows;

Using Orders table of the Superstores data set pre-packaged with Tableau app, lets demonstrate a simple example on using ordinal number suffixes.

Build viz structure

  • Drag dimension field City to the rows shelf.

  • Drag measure field Sales to the columns shelf.

  • Sort City descending by Sales.

Creating a calculated field to rank Sales along the City.

Creating a calculated field to condition how Ranking will be evaluated.

Build the story

Drag both the calculated fields created above (Ranking & Ordinal number suffix) to the tooltip shelf.

Order the tooltip as shown below;

Executing this adds now a better story in the viz through the tooltip.

This is how the viz looks.

I hope this article was helpful to you. To receive more of the Tableau tips and tricks, kindly join our mailing list by subscribing below.

Thank you for reading.


Top 35 Data Visualization Widgets

Take your data visualization skills to the next level with this FREE guide!!

FREE Tableau Desktop Course for Beginners

Get started with Tableau, a data visualization tool that allows you connect to nearly any data and create interactive visualizations.