top of page

Tableau Tips: Adding Ordinal Number Suffix

Updated: May 17, 2021


Adding ordinal number suffix in Tableau

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.

Blog.png
bottom of page