Dynamic Title for Singular / Plural

In Tableau it is always good practice to include a title so viewers and users are clear on what a visualization is representing. Below we have a treemap showing the Sales by sub-category for different regions. We also have a filter to enable Sales to be viewed for selected regions only:

Often in titles people use '(s)' so that they are covered for however many dimensions are included in a visualization:

However, with a simple calculation we can enable our 'Region(s)' part of the title to dynamically update to reflect the number of dimensions showing. In a new calculated field create as below:

If we drag this calculation onto our Details Marks card, we are able to add it into our title:

Now our title will dynamically update to show 'Market' or 'Markets' according with the number of regions.

Singular:

Plural:

Author:
John Power
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2024 The Information Lab