• Bernard

Tableau Tips: Adding Ordinal Number Suffix

Updated: Sep 3

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.