• Bernard

Tableau Tips: Adding Ordinal Number Suffix

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 impactful 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 these Tableau tips and tricks, subscribe to our email list and you will be first to know.

Thanks for reading.